Re: populating a [table]
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58722
interpreted = N
texte = Hi Jon, Did the email cause an extra space in your closing /then /else tags or is=20 that in your actual code perhaps? [/ then] [/ else] Though that would still be an issue with or without the table I suppose. Also, your group1field has an extra + it looks like after 'keywords': GROUP1FIELD=3Dnohtml+fontname+fampkg+keywords+&eqFAMDISPdatarq=3DT What should be your closing /if tag is missing the /, so that's the major=20 problem there. S At 02:07 PM 7/1/2004, you wrote: >I've been analyzing this in depth=85 and i can't figure out why i get 0 >results from it. i'm assuming something is off kilter in the way i'm >populating the table from my [search]. because if i remove the [table] >stuff, life is good again, and it works. i have spaces between the >fieldnames in the [founditems] context. is that a problem. i've tried >
and no luck there either??? > >[table name=3Ddupetable&fields=3DSKU,FAMDISP,FAMPREFIX,FAMPKG,VOLPKGNUM,[!] >[/!]FONTPREFIX,FONTNAME,KEYWORDS,PRINTERNAME,PKGPRICE,PRICE,CLASSIFICATI=20 >ON,[!] >[/!]DESIGNER,FOUNDRY,FOUNDRYCODE,PARENTROOT,SORTORDER,MISCINFO,ORIGCLASS= ,[!] >[/!]PKGONLY,ORIGDESIGNER,ORIGFOUNDRY,ORIGFOUNDRYCODE,ORIGVOLPKG,ORIGPART=20 >NUM,[!] >[/!]TAXABLE,DOWNLOAD,MANOPT,FOCUS,NOHTML,GLNUM,LIDUPE][!] >[/!][search db=3D../../www.philsfonts.com/vault/philsfonts.db[if >("[key]"=3D"4")][then]&eqFOCUSdatarq=3D[!] >[/!][fcs]&eqFAMDISPdatarq=3DT[/=20 >then][else]&[wrd]GROUP1datarq=3D[url][keyword][/url]&GROUP1FIELD=3D[!] >[/!]nohtml+fontname+fampkg+keywords+&eqFAMDISPdatarq=3DT[/=20 >else][if]&MANOPTsort=3D1&MANOPTtype[!] >[/!]=3Dtext&MANOPTsdir=3Dde&FONTNAMEsort=3D2&FONTNAMEtype=3Dtext&FONTNAMEsd= ir=3Das=20 >&VOLPKGNUMsort=3D[!] >[/!]3&FONTNAMEsumm=3DT&startat=3D[startat]&max=3D[rslts]][founditems][sku] >[famdisp] [famprefix] [fampkg][!] >[/!][volpkgnum] [fontprefix] [fontname] [keywords] [printername] >[pkgprice] [price] [classification] [designer][!] >[/!][foundry] [foundrycode] [parentroot] [sortorder] [miscinfo] >[origclass] [pkgonly] [origdesigner] [origfoundry][!] >[/!][origfoundrycode] [origvolpkg] [origpartnum] [taxable] [download] >[manopt] [focus] [nohtml][!] [glnum] [lidupe][/founditems][!] >[/!][/search][/table] > >[search table=3Ddupetable&eqLIDUPEdatarq=3DF] ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi Jon, Did the email cause an extra space in your closing /then /else tags or is=20 that in your actual code perhaps? [/ then] [/ else] Though that would still be an issue with or without the table I suppose. Also, your group1field has an extra + it looks like after 'keywords': GROUP1FIELD=3Dnohtml+fontname+fampkg+keywords+&eqFAMDISPdatarq=3DT What should be your closing /if tag is missing the /, so that's the major=20 problem there. S At 02:07 PM 7/1/2004, you wrote: >I've been analyzing this in depth=85 and i can't figure out why i get 0 >results from it. i'm assuming something is off kilter in the way i'm >populating the table from my [search]. because if i remove the [table] >stuff, life is good again, and it works. i have spaces between the >fieldnames in the [founditems] context. is that a problem. i've tried > and no luck there either??? > >[table name=3Ddupetable&fields=3DSKU,FAMDISP,FAMPREFIX,FAMPKG,VOLPKGNUM,[!] >[/!]FONTPREFIX,FONTNAME,KEYWORDS,PRINTERNAME,PKGPRICE,PRICE,CLASSIFICATI=20 >ON,[!] >[/!]DESIGNER,FOUNDRY,FOUNDRYCODE,PARENTROOT,SORTORDER,MISCINFO,ORIGCLASS= ,[!] >[/!]PKGONLY,ORIGDESIGNER,ORIGFOUNDRY,ORIGFOUNDRYCODE,ORIGVOLPKG,ORIGPART=20 >NUM,[!] >[/!]TAXABLE,DOWNLOAD,MANOPT,FOCUS,NOHTML,GLNUM,LIDUPE][!] >[/!][search db=3D../../www.philsfonts.com/vault/philsfonts.db[if >("[key]"=3D"4")][then]&eqFOCUSdatarq=3D[!] >[/!][fcs]&eqFAMDISPdatarq=3DT[/=20 >then][else]&[wrd]GROUP1datarq=3D[url][keyword][/url]&GROUP1FIELD=3D[!] >[/!]nohtml+fontname+fampkg+keywords+&eqFAMDISPdatarq=3DT[/=20 >else][if]&MANOPTsort=3D1&MANOPTtype[!] >[/!]=3Dtext&MANOPTsdir=3Dde&FONTNAMEsort=3D2&FONTNAMEtype=3Dtext&FONTNAMEsd= ir=3Das=20 >&VOLPKGNUMsort=3D[!] >[/!]3&FONTNAMEsumm=3DT&startat=3D[startat]&max=3D[rslts]][founditems][sku] >[famdisp] [famprefix] [fampkg][!] >[/!][volpkgnum] [fontprefix] [fontname] [keywords] [printername] >[pkgprice] [price] [classification] [designer][!] >[/!][foundry] [foundrycode] [parentroot] [sortorder] [miscinfo] >[origclass] [pkgonly] [origdesigner] [origfoundry][!] >[/!][origfoundrycode] [origvolpkg] [origpartnum] [taxable] [download] >[manopt] [focus] [nohtml][!] [glnum] [lidupe][/founditems][!] >[/!][/search][/table] > >[search table=3Ddupetable&eqLIDUPEdatarq=3DF] ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Gary Krockover
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:
Database field limit? (1998)
easy numfound search? (2001)
Need relative path explanation (1997)
Help! WebCat2 bug (1997)
[isfile] ? (1997)
Generating Report Totals (1997)
Any limit to [include] (1997)
[WebDNA] Height, width of images (2013)
SSL/Document Contains NO Data (1998)
docs for WebCatalog2 (1997)
Searching using numbers (1998)
errormessages.db (1997)
[WebDNA] Host List (2010)
First postarg not taking in $Commands (1997)
[SearchString] problem with [search] context (1997)
Quit revisited (1997)
Re1000001: Setting up shop (1997)
WebCat2: Master Counter snippet (1997)
If statement troubles (2002)
WebDNA 4.5.1 Now Available (2003)