Formatting a long list in a table

How to show the result of a search as a table, for instance a 30 row per 10 columns table.

numero = 43
interpreted = N
texte =
[Search db=bases.db&nefacturadata=0&facturasort=1&facturatype=num&facturasdir=de&max=300]<table border="0" cellspacing="1" cellpadding="1" bgcolor="white"><tr>[FoundItems]<td>[n_factura_rte]</td>[showif [index]\10]</tr><tr>[/showif][/FoundItems][hideif [numfound]\10]</tr>[/hideif]</table>[/search]
Explanation: First, move the original <tr>...</tr> outside of the founditems loop. The founditems loop keeps track of which founditem you currently are focused on. The backslash operator in the showif comparison says "is divisible by", i.e., "is [index] divisible by 10?" If so, close out the current table row and begin a new one. The last comparison makes sure that there is not an extraneous </tr> in the case when the number of items returned is also divisible by 10.
[Search db=bases.db&nefacturadata=0&facturasort=1
&facturatype=num&facturasdir=de&max=300]
<table border="0" cellspacing="1" cellpadding="1" bgcolor="white">
<tr>
[founditems]
<td>[n_factura_rte]</td>
[showif [index]\10]
</tr><tr>
[/showif]
[/FoundItems]
[hideif [numfound]\10]</tr>[/hideif]
</table>
[/search]

Explanation: First, move the original <tr>...</tr> outside of the founditems loop. The founditems loop keeps track of which founditem you currently are focused on. The backslash operator in the showif comparison says "is divisible by", i.e., "is [index] divisible by 10?" If so, close out the current table row and begin a new one.

The last comparison makes sure that there is not an extraneous </tr> in the case when the number of items returned is also divisible by 10. Joe D'Andrea

DOWNLOAD WEBDNA NOW!

Top Articles:

Tips and Tricks

A list of user-submitted tips ...

F.A.Q

A compilation of some user's questions...

[biotype]

BioType is a behavioral biometrics WebDNA function based on ADGS research and development (from version 8...

WebDNA reference

...

WebDNA Libraries

A list of available libraries for WebDNA...

WebDNA Modules

A list of the currently available modules...

Related Readings:

How old am I?

You want to express an age in years given the dob (mm/dd/yyyy) and today's date...

Find duplicate records

Find duplicate records and do something with them...

WebDNA interaction with zip

I have a project where I'm allowing several people to upload images...

File upload example

...

Export data to Excel

Here's a handy way to export your data to a text or Excel file...

WebDNA Google Map Mashup

Generate a Google map with pins on your database addresses...