tbsForum - Topic - nodata with dynamic table not working

By: kasper

Date: 2006-10-23

Time: 14:13

nodata with dynamic table not working

I can't get the nodata attribute to work with my dynamic table. what an i doing wrong??

<table border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
        [cell;block=tr+tr;magenet=table;mtype=m+m]
          <td align="center" valign="top" width="150" height="100">
            <div width="150" height="150" onMouseOver="info('vis',[cell.$])" onMouseOut="info('',[cell.$])" style="width:150px; height:118px;">
            <img src="bdbgen.php?id=[cell.[col.val;block=td].id]&str=1" border="0" valign="middle" style="cursor: hand;" onClick="popup('bdbpopup.php?id=[cell.[col.val].id]&h=[cell.[col.val].mediumyp]&w=[cell.[col.val].mediumx]&str=2','popup',[cell.[col.val].mediumx],[cell.[col.val].mediumyp]);">
            </div>

            <input name="markering[[cell.[col.val].count]]" type="checkbox" value="[cell.[col.val].id]" onMouseOver="info('marker', [cell.$]);" onMouseOut="info('',[cell.$]);">

            <span onMouseOver="info('info', [cell.$]);" onMouseOut="info('',[cell.$]);">
            <img src="gfx/info.gif" style="cursor: hand;" onClick="visDivVindue('infobox',200); infobox([cell.[col.val].count],[cell.[col.val].id],'[cell.[col.val].filnavn]','[cell.[col.val].str] kb','[cell.[col.val].x]px x [cell.[col.val].y]px','[cell.[col.val].datosp]','[cell.[col.val].taeller]', '[cell.[col.val].upload_af]', [cell.[col.val].mediumyp],[cell.[col.val].mediumx])">



            <div id="infoboxkat[cell.[col.val].count]" style="display:inline;">
            <div><a href="index.php?katid=[kdata2.id; block=div; p1= [cell.$]; p2= [col.val]]">[kdata2.tekst]</a></div><br>

            </div>
        </span>

        <span onMouseOver="info('hojr', [cell.$]);" onMouseOut="info('',[cell.$]);">
        <img src="gfx/hojr.gif" style="cursor: hand;" onclick="document.location = 'bdrot.php?[var.server.QUERY_STRING; if [val] == ''; then id=[cell.[col.val].id]; else [var.server.QUERY_STRING]&id=[cell.[col.val].id]]&vej=hoj'">
        </span>

        <span onMouseOver="info('ret', [cell.$]);" onMouseOut="info('',[cell.$]);">
            <img src="gfx/ret.gif" style="cursor: hand;" onclick="document.location = 'bdbret.php?id=[cell.[col.val].id]&h=[cell.[col.val].y]&w=[cell.[col.val].x]'">
        </span>

        <span onMouseOver="info('vens', [cell.$]);" onMouseOut="info('',[cell.$]);">
        <img src="gfx/vens.gif" style="cursor: hand;" onclick="document.location = 'bdrot.php?[var.server.QUERY_STRING; if [val] == ''; then id=[cell.[col.val].id]; else [var.server.QUERY_STRING]&id=[cell.[col.val].id]]&vej=ven'">
        </span>
        </td>
        <td>
        [cell.[col.val;block=td;nodata].id]
        <td>
        </tr>
        <tr>
          <td id="raekke[cell.$]" colspan="[var.antalperlinie]" align="center" style="color:#F8A426; background-repeat:repeat-x;"> </td>
        </tr>
      </table>

                  </td>
              </tr>
            </table>
        </td>
    </tr>
</table>

you can see the rest of my code here http://www.tinybutstrong.com/forum.php?msg_id=6477#

By: kasper

Date: 2006-10-23

Time: 14:30

Re: nodata with dynamic table not working

forcause i get all these errors

TinyButStrong Error in field [cell.column_5.id...] : item 'column_5' is not an existing key in the array. This message can be cancelled using parameter 'noerr'.

TinyButStrong Error in field [cell.column_5.id...] : item 'column_5' is not an existing key in the array. This message can be cancelled using parameter 'noerr'.

TinyButStrong Error in field [cell.column_5.x...] : item 'column_5' is not an existing key in the array. This message can be cancelled using parameter 'noerr'.

TinyButStrong Error in field [cell.column_5.y...] : item 'column_5' is not an existing key in the array. This message can be cancelled using parameter 'noerr'.

TinyButStrong Error in field [cell.column_5.id...] : item 'column_5' is not an existing key in the array. This message can be cancelled using parameter 'noerr'.

TinyButStrong Error in field [cell.column_5.id...] : item 'column_5' is not an existing key in the array. This message can be cancelled using parameter 'noerr'.

TinyButStrong Error in field [cell.column_5.id...] : item 'column_5' is not an existing key in the array. This message can be cancelled using parameter 'noerr'.

TinyButStrong Error in field [cell.column_5.count...] : item 'column_5' is not an existing key in the array. This message can be cancelled using parameter 'noerr'.

TinyButStrong Error in field [cell.column_5.mediumx...] : item 'column_5' is not an existing key in the array. This message can be cancelled using parameter 'noerr'.

TinyButStrong Error in field [cell.column_5.mediumyp...] : item 'column_5' is not an existing key in the array. This message can be cancelled using parameter 'noerr'.
.... and so on

By: Skrol29

Date: 2006-10-23

Time: 20:32

Re: nodata with dynamic table not working

Hi Kasper,

According to your PHP code, if you have $antalperlinie=5, then $col has items from 1 to 5, but $data goes only from 'column_1' to 'column_4' for each row. I think this is the problem.

It seems that you're trying to build dynamical multi-column display. But have you seen parameter "serial" ? It does the multi-column display and you could arrange it to be dynamic. There is an exemple in line.

Just another comment about your tag

[cell;block=tr+tr;magenet=table;mtype=m+m]

You should use parameter "bmagnet" instead of "magnet" & "mtype". Those two last are for fields only.

By: kasper

Date: 2006-10-24

Time: 09:24

Re: nodata with dynamic table not working

No you are no rigth in that case of $antalperlinie and column_... that works just fine.$antalperlinie can be set to anything from 1 and up that is why i need to make a dynamic table and not serial as asked me to look at. I have printed the complete array from the mysql query that gives me the problem below. notice that $antalperlinie = 5 and not 4 as it was in my previous thread.

So this is the problem. As you can see in the array below there array isn't complete . it stops at [4][column_2]. thats why i get:

This is simply because there isn't any more posts in the mysql database. So I wanted too tell TinyButStrong to insert an new td if there is no data. in other words a blank td.

<td>
[cell.[col.val;block=td;nodata].id]
<td>

(I think that's why you thought I wanted to make multi-column display.)

but it dosn't work.

maybe i need to feel out the array with "blanks" $data[$row]["column_".$col]["id"] = ''; until i get to [4][column_5] but im not sure how the nodata really works.

Maybe u are rigth about the [cell;block=tr+tr;magenet=table;mtype=m+m] but after i have inserted

if($antal_res != 0){
$TBS -> MergeBlock('col','array',$columns);
}

in the main code, it looks like it works just fine with the magnet and mtype. ($antal_res is just a myql_num_rows()). But if bmagnet is better I'll change it.

But the big question is how do i get to insert the blank td if there is no data?

By: Skrol29

Date: 2006-10-24

Time: 18:08

Re: nodata with dynamic table not working

Hi,

So it seems that the problem comes from the last line of your table which may not have enought records to be completed to the bottom.
This is not really a TBS problem but you can try the following:

Just add this code after the loop that read records.
This code just add empty records to feed the last row.

if (($count>0) and ($col!=1)) {
for ($i=$col;$i<$antalperlinie,$i++) {
    $data[$row]["column_".$i]["id"] = "";
    $data[$row]["column_".$i]["mediumx"] = "";
    $data[$row]["column_".$i]["mediumy"] = "";
    $data[$row]["column_".$i]["mediumyp"] = "";
    $data[$row]["column_".$i]["taeller"] = "";
    $data[$row]["column_".$i]["dato"] = "";
    $data[$row]["column_".$i]["datosp"] = "";
    $data[$row]["column_".$i]["x"] = "";
    $data[$row]["column_".$i]["y"] = "";
    $data[$row]["column_".$i]["str"] = "";
    $data[$row]["column_".$i]["filnavn"] = "";
    $data[$row]["column_".$i]["upload_af"] = "";
    $data[$row]["column_".$i]["count"] = "";
}
}

By: kasper

Date: 2006-10-24

Time: 18:21

Re: nodata with dynamic table not working

yes could also understand i if that was problem but it still does not work i have tryed that. (but the array is complete now of cause)

its like it dosn't understand nodata at all

By: Skrol29

Date: 2006-10-24

Time: 18:33

Re: nodata with dynamic table not working

Yes, "nodata" will not work has you wish in this case. The nodata section is displayed instead of all other sections of the block only in case there is no record at all. In you case, they are 4 records : $data[1] , $data[2] , ...
"nodata" is not actived for block "col" neither, because this block has also records : $columns[1] , $columns[2] ...

By: kasper

Date: 2006-10-24

Time: 20:54

Re: nodata with dynamic table not working

but what can i then do?? Conditional display maybe?

By: Skrol29

Date: 2006-10-24

Time: 23:57

Re: nodata with dynamic table not working

Hi Kasper,

I can make 2 suggestions :

1/ First one is to perseverate in the solution of supplementing the last row with empty columns when it is necessary. This solution should logically work and you can found out why it doesn't work by debuging your script.
If you don't succeed, then send me a piece of script in order to reproduce your problem.

2/ Take a look at the parameter "serial". i think it can do a part of what you're trying to do. I you can use it after merging the number of column you need.

By: kasper

Date: 2006-10-25

Time: 10:35

Re: nodata with dynamic table not working

the problem with serial as I see it. is that need to call bx_1. bx_2 and so on(taken from the exsample) with is made in the tamplate file. how can it then be dynamic when i dont know how many td there is going to be. the numbers of td is set by the $antalperlinie var and that needs to be changeable or else the system dosn't work like it should.

By: kasper

Date: 2006-10-25

Time: 10:52

Re: nodata with dynamic table not working

there is no problem if there is only one line in the table (one td) then i just make $antalperlinie smaler with.

if($antalposter < $antalperlinie){
$antalperlinie = $antalposter;
}

but if i all ready have made one line that option is not possible

By: Skrol29

Date: 2006-10-25

Time: 22:37

Re: nodata with dynamic table not working

Hi Kasper,

It can be dynamic exactly the same way you make it dynamic in your current solution.

Here is the spirit:

<table>

<tr>
    <td> First column (optional) </td>
    <td> [c1.val;block=td] </td>
</tr>

<tr>
    <td> [r;block=tr;serial] First column (optional) </td>
    <td> Item = [r_[c2.val;block=td].item;block=td] </td>
    <td> [r_0;block=td] Empty cell </td>
</tr>

</table>

PHP:

$TBS->MergeBlock('c1,c2','num',$antalperlinie); // Extend columns
$TBS->MergeBlock('r',$data); // Merge data in serial mode

By: kasper

Date: 2006-10-25

Time: 23:00

Re: nodata with dynamic table not working

ahhh ok didn't know that, maybe it would be a good idea to write a little note about that in the manual. by the the way there is a part of the english manualis that French under Calling a Method/Remarks. just so that u know it.

By: Skrol29

Date: 2006-10-25

Time: 23:12

Re: nodata with dynamic table not working

Serial mode is explain in the manual.
I'll check your discovery about a French remark in the English version.

By: kasper

Date: 2006-10-25

Time: 23:53

Re: nodata with dynamic table not working

nope its not working

php

while($resultat = mysql_fetch_array($find_ressultet)){
    $data[$count]["id"] = $resultat['id'];
    $data[$count]["mediumx"] = $resultat['mediumx'];
    $data[$count]["mediumy"] = $resultat['mediumy'];
    $data[$count]["taeller"] = $resultat['taeller'];
    $data[$count]["dato"] = $resultat['dato'];
    $data[$count]["datosp"] = datesplitter($resultat['dato']);
    $data[$count]["x"] = $resultat['x'];
    $data[$count]["y"] = $resultat['y'];
    $data[$count]["str"] = $resultat['str'];
    $data[$count]["filnavn"] = $resultat['filnavn'];
    $data[$count]["upload_af"] = $resultat['upload_af'];
    $data[$count]["count"] = $count;
    $count++;
}

$TBS = new clsTinyButStrong;
$TBS -> LoadTemplate('templates/index.tpl');
$TBS -> MergeBlock('aps','array',$apsoption);
//if($antal_res != 0){
    //$TBS -> MergeBlock('col','array',$columns);
//}
$TBS -> MergeBlock('c1,c2','num',$antalperlinie);
$TBS -> MergeBlock('cell','array',"data");
//$TBS -> MergeBlock('kdata2','array','data[%p1%][%p2%][kdata]');

$TBS -> Show();

template

<table border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>

          <td align="center" valign="top" width="150" height="100">
            [data_[c2.val; block=td].id; block=td;]
            [data;block=tr;serial]
            </td>
        <td>
        [data_0;block=td]
        [data;block=tr;serial]
        <td>
        </tr>
      </table>

result

<table border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>

          <td align="center" valign="top" width="150" height="100">
            [data_1.id; block=td;]
            [data;block=tr;serial]
            </td><td align="center" valign="top" width="150" height="100">
            [data_2.id; block=td;]
            [data;block=tr;serial]
            </td><td align="center" valign="top" width="150" height="100">
            [data_3.id; block=td;]
            [data;block=tr;serial]
            </td><td align="center" valign="top" width="150" height="100">
            [data_4.id; block=td;]
            [data;block=tr;serial]
            </td><td align="center" valign="top" width="150" height="100">
            [data_5.id; block=td;]
            [data;block=tr;serial]
            </td>
        <td>
        [data_0;block=td]
        [data;block=tr;serial]
        <td>
        </tr>
      </table>

By: kasper

Date: 2006-10-26

Time: 00:03

Re: nodata with dynamic table not working

ahhh little to fast there data needs to be cell, but still get a strange result.

TinyButStrong Error in block's definition [cell_0...] : tag <td> or </td> is not found.

<table border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>

          <td align="center" valign="top" width="150" height="100">
            [cell_1.id; block=td;]

            </td><td align="center" valign="top" width="150" height="100">
            [cell_2.id; block=td;]
            <td align="center" valign="top" width="150" height="100">
            998

            </td>
            </td><td align="center" valign="top" width="150" height="100">
            [cell_3.id; block=td;]
            <td align="center" valign="top" width="150" height="100">
            997
            [cell;block=tr;serial]
            </td>
            </td><td align="center" valign="top" width="150" height="100">
            [cell_4.id; block=td;]
            <td align="center" valign="top" width="150" height="100">
            996
            [cell;block=tr;serial]
            </td>
            </td><td align="center" valign="top" width="150" height="100">
            994
            [cell;block=tr;seri<td align="center" valign="top" width="150" height="100">
            995
            [cell;block=tr;serial]
            </td>   </tr><tr>

          <td align="center" valign="top" width="150" height="100">
            [cell_1.id; block=td;]

            </td><td align="center" valign="top" width="150" height="100">
            [cell_2.id; block=td;]
            <td align="center" valign="top" width="150" height="100">
            993

            </td>
            </td><td align="center" valign="top" width="150" height="100">
            [cell_3.id; block=td;]
            <td align="center" valign="top" width="150" height="100">
            992
            [cell;block=tr;serial]
            </td>
            </td><td align="center" valign="top" width="150" height="100">
            [cell_4.id; block=td;]
            <td align="center" valign="top" width="150" height="100">
            991
            [cell;block=tr;serial]
            </td>
            </td><td align="center" valign="top" width="150" height="100">
            989
            [cell;block=tr;seri<td align="center" valign="top" width="150" height="100">
            990
            [cell;block=tr;serial]
            </td>   </tr><tr>

          <td align="center" valign="top" width="150" height="100">
            [cell_1.id; block=td;]

            </td><td align="center" valign="top" width="150" height="100">
            [cell_2.id; block=td;]
            <td align="center" valign="top" width="150" height="100">
            988

            </td>
            </td><td align="center" valign="top" width="150" height="100">
            [cell_3.id; block=td;]
            <td align="center" valign="top" width="150" height="100">
            987
            [cell;block=tr;serial]
            </td>
            </td><td align="center" valign="top" width="150" height="100">
            [cell_4.id; block=td;]
            <td align="center" valign="top" width="150" height="100">
            986
            [cell;block=tr;serial]
            </td>
            </td><td align="center" valign="top" width="150" height="100">
            984
            [cell;block=tr;seri<td align="center" valign="top" width="150" height="100">
            985
            [cell;block=tr;serial]
            </td>   </tr><tr>

          <td align="center" valign="top" width="150" height="100">
            [cell_1.id; block=td;]

            </td><td align="center" valign="top" width="150" height="100">
            [cell_2.id; block=td;]
            <td align="center" valign="top" width="150" height="100">
            983

            </td>
            </td><td align="center" valign="top" width="150" height="100">
            [cell_3.id; block=td;]
            <td align="center" valign="top" width="150" height="100">
            982
            [cell;block=tr;serial]
            </td>
            </td><td align="center" valign="top" width="150" height="100">
            [cell_4.id; block=td;]
            <td align="center" valign="top" width="150" height="100">

            [cell;block=tr;serial]
            </td>
            </td><td align="center" valign="top" width="150" height="100">

            [cell;block=tr;serial]<td align="center" valign="top" width="150" height="100">

            [cell;block=tr;serial]
            </td></tr>
      </table>

                  </td>
              </tr>
            </table>

nodata with dynamic table not working

nodata with dynamic table not working

Re: nodata with dynamic table not working

Re: nodata with dynamic table not working

Re: nodata with dynamic table not working

Re: nodata with dynamic table not working

Re: nodata with dynamic table not working

Re: nodata with dynamic table not working

Re: nodata with dynamic table not working

Re: nodata with dynamic table not working

Re: nodata with dynamic table not working

Re: nodata with dynamic table not working

Re: nodata with dynamic table not working

Re: nodata with dynamic table not working

Re: nodata with dynamic table not working

Re: nodata with dynamic table not working

Re: nodata with dynamic table not working

New message