Re: [WebDNA] limit found per row
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107500
interpreted = N
texte = sgbc cebu,Now you have a few examples.. but here this one (below) will fill out =the blank 's the way you asked it to.. and also allow you to change =the number of items per row, at the top of the code. The second setting =([numSampleImages]), is just for populating the test database (I used a =[table]).Open the below on your webdna webserver. (Add the comment at the top to =make webdna parse the page, if your setup is set to require that.)-G=--------------------------------------------------------------------------=-------------------------------------------------------------[text]numItemsPerTR=3D7[/text][text]numSampleImages=3D22[/text][table name=3DcebuSample&fields=3Dimage][/table][loop start=3D1&end=3D[numSampleImages]&advance=3D1][Append table=3DcebuSample]image=3Dimage[index].jpg[/Append][/loop]
Untitled[!]---This does not complete the TR when there are a number of =founditems which is not divisible by 3[search table=3DcebuSample&neimagedata=3DfindAll][founditems][showif [index]\3][/showif][/founditems][/search]
---[/!][!]---this will fill out the last with the right number of =these: " " ...as was requested.---[/!][Search =table=3DcebuSample&neimagedatarq=3DfindZemAll[!]---&asimagesort=3D1---[/!]=&rank=3Doff][text]totalItems=3D[numfound][/text][FoundItems][showif [index]=3D1][text]TRstatus=3Dopen[/text][text]TDsThisTR=3D0[/text][/showif]=[text]TDsThisTR=3D[math][TDsThisTR]+1[/math][/text][showif [index]\[numItemsPerTR]][text]TRstatus=3Dclosed[/text][hideif [index]=3D[totalItems]]=[text]TRstatus=3Dopen[/text][text]TDsThisTR=3D0[/text]=[/hideif][/showif][/FoundItems][if ("[TRstatus]"=3D"open")][then][!]---here we fill in any empty =TD slots with blanks, and close the TR---[/!]=[text]numBlanksTDsNeeded=3D[math][numItemsPerTR]-[TDsThisTR][/math][/text]=[loop =start=3D1&end=3D[numBlanksTDsNeeded]&advance=3D1][/loop][/then][/if][/Search]
A | B | C |
![]() |
= |
=--------------------------------------------------------------------------=-------------------------------------------------------------=
Associated Messages, from the most recent to the oldest:
sgbc cebu,Now you have a few examples.. but here this one (below) will fill out =the blank 's the way you asked it to.. and also allow you to change =the number of items per row, at the top of the code. The second setting =([numSampleImages]), is just for populating the test database (I used a =
[table]).Open the below on your webdna webserver. (Add the comment at the top to =make webdna parse the page, if your setup is set to require that.)-G=--------------------------------------------------------------------------=-------------------------------------------------------------
[text]numItemsPerTR=3D7[/text]
[text]numSampleImages=3D22[/text][table name=3DcebuSample&fields=3Dimage][/table][loop start=3D1&end=3D[numSampleImages]&advance=3D1][Append table=3DcebuSample]image=3Dimage[index].jpg[/Append][/loop]
Untitled[!]---This does not complete the TR when there are a number of =founditems which is not divisible by 3[search table=3DcebuSample&neimagedata=3DfindAll]
[founditems][showif [index]\3][/showif][/founditems][/search]
---[/!]
[!]---this will fill out the last with the right number of =these: " " ...as was requested.---[/!][Search =table=3DcebuSample&neimagedatarq=3DfindZemAll
[!]---&asimagesort=3D1---[/!]=&rank=3Doff]
[text]totalItems=3D[numfound][/text]
[founditems][showif [index]=3D1]
[text]TRstatus=3Dopen[/text]
[text]TDsThisTR=3D0[/text][/showif]=
[text]TDsThisTR=3D
[math][TDsThisTR]+1[/math][/text][showif [index]\[numItemsPerTR]]
[text]TRstatus=3Dclosed[/text][hideif [index]=3D[totalItems]]=
[text]TRstatus=3Dopen[/text]
[text]TDsThisTR=3D0[/text]=[/hideif][/showif][/FoundItems][if ("[TRstatus]"=3D"open")][then]
[!]---here we fill in any empty =TD slots with blanks, and close the TR---[/!]=
[text]numBlanksTDsNeeded=3D
[math][numItemsPerTR]-[TDsThisTR][/math][/text]=[loop =start=3D1&end=3D[numBlanksTDsNeeded]&advance=3D1][/loop][/then][/if][/Search]
A | B | C |
![]() |
= |
=--------------------------------------------------------------------------=-------------------------------------------------------------=
Govinda
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
HELP-1!!! (1998)
synching databases on multiple servers (1997)
Unformatted Messages (1998)
Version f1 status (1997)
transferring values (1998)
Altavista causes a problem? (1998)
SKU (1997)
suggestion (1997)
External Images (1998)
[include] affect on filepaths for links? (1997)
NEW INFO: I'm stuck: Can't open order file. (2000)
Siteedit (1999)
Emailer (1998)
TEXTA-D (2003)
Running _every_ page through WebCat ? (1997)
Problems with [Search] param - Mac Plugin b15 (1997)
alternatives for WebDNA (2004)
Plugin vs. CGI (1998)
Random (2000)
Still having problems with Authen (1997)