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| A | B | C | [search table=3DcebuSample&neimagedata=3DfindAll][founditems]| [image] | [showif [index]\3] |
[/showif][/founditems] [/search] ---[/!][!]---this will fill out the last | with the right number of =these: "| | " ...as was requested.---[/!]| A | B | C |
[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]
=--------------------------------------------------------------------------=-------------------------------------------------------------=
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| A | B | C | [search table=3DcebuSample&neimagedata=3DfindAll][founditems]| [image] | [showif [index]\3] |
[/showif][/founditems] [/search] ---[/!][!]---this will fill out the last |
with the right number of =these: "| | " ...as was requested.---[/!]| A | B | C |
[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]
=--------------------------------------------------------------------------=-------------------------------------------------------------=
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:
Q: writefile and uploads. (1998)
WebCat & cookies (1998)
Summ=T Problem (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
[ShowNext] (1997)
Editing the search string (1997)
Search returns all, not 20 (1997)
Associative lookup style? + bit more (1997)
[WebDNA] WebDNA used in US Government work? (2013)
[WebDNA] [WSC] WebDNA Development Summit (2014)
RE: Deafness (1998)
emailer settings and control questions (1997)
test - ignore (2008)
PCS Frames (1997)
Sending mail (was forms and variables) (1998)
Resume Catalog ? (1997)
Viewing old carts (was FEW QUESTIONS) (1997)
FISKARS (2003)
credit card authorization question (1997)
WebCat2 Append problem (B14Macacgi) (1997)