Re: populating a [table]
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58724
interpreted = N
texte = One technique we use to eliminate complex formatting issues is to =20declare the table first, close it empty, then put APPEND contexts in =20the founditems set to populate the table; less problems with errant =20text values, carriage returns, etc.On Jul 1, 2004, at 12:07 PM, Jon Young wrote:> I've been analyzing this in depth=85 and i can't figure out why i get =0 =20> results from it. i'm assuming something is off kilter in the way i'm =20=> populating the table from my [search]. because if i remove the [table] ==20> stuff, life is good again, and it works. i have spaces between the =20> fieldnames in the [founditems] context. is that a problem. i've tried =20=>
and no luck there either???>> [table =name=3Ddupetable&fields=3DSKU,FAMDISP,FAMPREFIX,FAMPKG,VOLPKGNUM,[!]> =[/!]FONTPREFIX,FONTNAME,KEYWORDS,PRINTERNAME,PKGPRICE,PRICE,CLASSIFICAT=20=> ION,[!]> =[/!]DESIGNER,FOUNDRY,FOUNDRYCODE,PARENTROOT,SORTORDER,MISCINFO,ORIGCLAS=20=> S,[!]> =[/!]PKGONLY,ORIGDESIGNER,ORIGFOUNDRY,ORIGFOUNDRYCODE,ORIGVOLPKG,ORIGPAR=20=> TNUM,[!]> [/!]TAXABLE,DOWNLOAD,MANOPT,FOCUS,NOHTML,GLNUM,LIDUPE][!]> [/!][search db=3D../../www.philsfonts.com/vault/philsfonts.db[if =20> ("[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&FONTNAMEs=dir=3Da=20> s&VOLPKGNUMsort=3D[!]> [/!]3&FONTNAMEsumm=3DT&startat=3D[startat]&max=3D[rslts]][founditems][sk=u] =20> [famdisp] [famprefix] [fampkg][!]> [/!][volpkgnum] [fontprefix] [fontname] [keywords] [printername] =20> [pkgprice] [price] [classification] [designer][!]> [/!][foundry] [foundrycode] [parentroot] [sortorder] [miscinfo] =20> [origclass] [pkgonly] [origdesigner] [origfoundry][!]> [/!][origfoundrycode] [origvolpkg] [origpartnum] [taxable] [download] =20=> [manopt] [focus] [nohtml][!] [glnum] [lidupe][/founditems][!]> [/!][/search][/table]>> [search table=3Ddupetable&eqLIDUPEdatarq=3DF]>> --> Jon Young | Phil's Fonts> 501 Olney Sandy Spring Road, Sandy Spring, MD 20860> tel 800-681-9375 or 301-260-2285 | fax 301-260-2277> mailto: webmaster@philsfonts.com | http://www.philsfonts.com>>> -------------------------------------------------------------> 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 =20> > Web Archive of this list is at: http://webdna.smithmicro.com/>>Larry Hewitt360.807.1100 =OFFICEHCO, LLC360.807.1103 =FAX1133 Kresky NE #106360.508.6231 CELLCentralia, WA 98531larryh@hewittco.comwww.hewittco.com=www.votewashington.org-------------------------------------------------------------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:
One technique we use to eliminate complex formatting issues is to =20declare the table first, close it empty, then put APPEND contexts in =20the founditems set to populate the table; less problems with errant =20text values, carriage returns, etc.On Jul 1, 2004, at 12:07 PM, Jon Young wrote:> I've been analyzing this in depth=85 and i can't figure out why i get =0 =20> results from it. i'm assuming something is off kilter in the way i'm =20=> populating the table from my [search]. because if i remove the [table] ==20> stuff, life is good again, and it works. i have spaces between the =20> fieldnames in the [founditems] context. is that a problem. i've tried =20=> and no luck there either???>> [table =name=3Ddupetable&fields=3DSKU,FAMDISP,FAMPREFIX,FAMPKG,VOLPKGNUM,[!]> =[/!]FONTPREFIX,FONTNAME,KEYWORDS,PRINTERNAME,PKGPRICE,PRICE,CLASSIFICAT=20=> ION,[!]> =[/!]DESIGNER,FOUNDRY,FOUNDRYCODE,PARENTROOT,SORTORDER,MISCINFO,ORIGCLAS=20=> S,[!]> =[/!]PKGONLY,ORIGDESIGNER,ORIGFOUNDRY,ORIGFOUNDRYCODE,ORIGVOLPKG,ORIGPAR=20=> TNUM,[!]> [/!]TAXABLE,DOWNLOAD,MANOPT,FOCUS,NOHTML,GLNUM,LIDUPE][!]> [/!][search db=3D../../www.philsfonts.com/vault/philsfonts.db[if =20> ("[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&FONTNAMEs=dir=3Da=20> s&VOLPKGNUMsort=3D[!]> [/!]3&FONTNAMEsumm=3DT&startat=3D[startat]&max=3D[rslts]][founditems][sk=u] =20> [famdisp] [famprefix] [fampkg][!]> [/!][volpkgnum] [fontprefix] [fontname] [keywords] [printername] =20> [pkgprice] [price] [classification] [designer][!]> [/!][foundry] [foundrycode] [parentroot] [sortorder] [miscinfo] =20> [origclass] [pkgonly] [origdesigner] [origfoundry][!]> [/!][origfoundrycode] [origvolpkg] [origpartnum] [taxable] [download] =20=> [manopt] [focus] [nohtml][!] [glnum] [lidupe][/founditems][!]> [/!][/search][/table]>> [search table=3Ddupetable&eqLIDUPEdatarq=3DF]>> --> Jon Young | Phil's Fonts> 501 Olney Sandy Spring Road, Sandy Spring, MD 20860> tel 800-681-9375 or 301-260-2285 | fax 301-260-2277> mailto: webmaster@philsfonts.com | http://www.philsfonts.com>>> -------------------------------------------------------------> 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 =20> > Web Archive of this list is at: http://webdna.smithmicro.com/>>Larry Hewitt360.807.1100 =OFFICEHCO, LLC360.807.1103 =FAX1133 Kresky NE #106360.508.6231 CELLCentralia, WA 98531larryh@hewittco.comwww.hewittco.com=www.votewashington.org-------------------------------------------------------------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/
Larry Hewitt
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:
WebCat2 - [format thousands] (1997)
Re:no [search] with NT (1997)
Some Questions (1997)
Showing unopened cart (1997)
How To Install (2003)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
OK, here goes... (1997)
Re1000001: Setting up shop (1997)
[random] only for 1-100??? (1997)
SUBMIT buttons not working.... (2000)
Summing fields (1997)
Bug or syntax error on my part? (1997)
Search in 2 or more catalogs (1997)
serial number generation (1997)
2nd WebCatalog2 Feature Request (1996)
Beta 18 (1997)
Possible Bug in 2.0b15.acgi (1997)
FW: ANother SHOWIF problem (1997)
WebCat2.0 [format thousands .0f] no go (1997)
Showif Or (2000)