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:

F.A.Q

A compilation of some user's questions...

AWS Raw WebDNA LAMP-Plus WebServer

Amazon Web Services (AWS) README for Machine Image ID...

Download WebDNA Applications

WebDNA applications...

Tips and Tricks

A list of user-submitted tips ...

WebDNA Libraries

A list of available libraries for WebDNA...

Technical Change History

This Technical Change History provides a reverse chronological list of WebDNA changes...

Related Readings:

Spaghetti code

How to get rid of very long search strings...

random password-generator code

Generate a random alpha-numeric string...

Calculating Standard Deviation

...

Setting a 30-minute Cookie

Configuring the expires time for a short-term cookie is tricky...

Redefining [date] & [time] to match your time zone

Your server is not always in the same time zone as your web site...

reCAPTCHA code

reCAPTCHA helps prevent automated abuse of your site (such as comment spam or bogus registrations) by using a CAPTCHA to ensure that only humans perform certain actions...