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 =20 declare the table first, close it empty, then put APPEND contexts in =20 the founditems set to populate the table; less problems with errant =20 text 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 = OFFICE HCO, LLC360.807.1103 = FAX 1133 Kresky NE #106360.508.6231 CELL Centralia, WA 98531larryh@hewittco.com www.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:

    
  1. Re: populating a [table] ( Brian Fries 2004)
  2. Re: populating a [table] ( Larry Hewitt 2004)
  3. Re: populating a [table] ( Jon Young 2004)
  4. Re: populating a [table] ( Gary Krockover 2004)
  5. populating a [table] ( Jon Young 2004)
One technique we use to eliminate complex formatting issues is to =20 declare the table first, close it empty, then put APPEND contexts in =20 the founditems set to populate the table; less problems with errant =20 text 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 = OFFICE HCO, LLC360.807.1103 = FAX 1133 Kresky NE #106360.508.6231 CELL Centralia, WA 98531larryh@hewittco.com www.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)