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:

    
  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)
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:

Comments in db? (1997) dynamic giffing. (2000) Online reference (1997) Sorting Numbers (1997) writing db to disk (1997) problems with WebCat-Plugin () WebTen and WebCat (1997) [OT] CSS div/span (2004) shipcost (1997) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Database Security (1998) locking variables? (2000) Error, 101 a DNS problem ? (1997) pc (1997) WebDNA tags in WebMerchant email templates ... (1997) WebCat for mass emailings (1997) DB not found error (2004) Prevent multiple appends with Reload Button (1997) [WebDNA] Data Type Bool (2009) Is the Finder required? (1998)