Re: populating a [table]

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58723
interpreted = N
texte = Check on all those items. Thanks. But there's something about the =20 [table] context that is causing [numfound]=3D0. And I've tried searching = =20 the table with other parameters other than LIDUPE, which simply has =20 either an 'F' or 'T' in it's field. And [numfound]=3D0 is always zero. = so =20 i'm thinking the problem is either in the populating of the table, or =20= the searching of the table. but my experience with tables is minimal. =20= anybody have any similar [table] issues? On Jul 1, 2004, at 3:33 PM, Gary Krockover wrote: > Hi Jon, > > Did the email cause an extra space in your closing /then /else tags or = =20 > is that in your actual code perhaps? > > [/ then] [/ else] > > Though that would still be an issue with or without the table I =20 > 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 =20= > major 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 =20 >> name=3Ddupetable&fields=3DSKU,FAMDISP,FAMPREFIX,FAMPKG,VOLPKGNUM,[!] >> = [/!]FONTPREFIX,FONTNAME,KEYWORDS,PRINTERNAME,PKGPRICE,PRICE,CLASSIFICA=20= >> TI ON,[!] >> = [/!]DESIGNER,FOUNDRY,FOUNDRYCODE,PARENTROOT,SORTORDER,MISCINFO,ORIGCLA=20= >> SS ,[!] >> = [/!]PKGONLY,ORIGDESIGNER,ORIGFOUNDRY,ORIGFOUNDRYCODE,ORIGVOLPKG,ORIGPA=20= >> RT 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&FONTNAMEs= dir=3D=20 >> as &VOLPKGNUMsort=3D[!] >> [/!]3&FONTNAMEsumm=3DT&startat=3D[startat]&max=3D[rslts]][founditems][s= ku] >> [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 =20 > > Web Archive of this list is at: http://webdna.smithmicro.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 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)
Check on all those items. Thanks. But there's something about the =20 [table] context that is causing [numfound]=3D0. And I've tried searching = =20 the table with other parameters other than LIDUPE, which simply has =20 either an 'F' or 'T' in it's field. And [numfound]=3D0 is always zero. = so =20 i'm thinking the problem is either in the populating of the table, or =20= the searching of the table. but my experience with tables is minimal. =20= anybody have any similar [table] issues? On Jul 1, 2004, at 3:33 PM, Gary Krockover wrote: > Hi Jon, > > Did the email cause an extra space in your closing /then /else tags or = =20 > is that in your actual code perhaps? > > [/ then] [/ else] > > Though that would still be an issue with or without the table I =20 > 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 =20= > major 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 =20 >> name=3Ddupetable&fields=3DSKU,FAMDISP,FAMPREFIX,FAMPKG,VOLPKGNUM,[!] >> = [/!]FONTPREFIX,FONTNAME,KEYWORDS,PRINTERNAME,PKGPRICE,PRICE,CLASSIFICA=20= >> TI ON,[!] >> = [/!]DESIGNER,FOUNDRY,FOUNDRYCODE,PARENTROOT,SORTORDER,MISCINFO,ORIGCLA=20= >> SS ,[!] >> = [/!]PKGONLY,ORIGDESIGNER,ORIGFOUNDRY,ORIGFOUNDRYCODE,ORIGVOLPKG,ORIGPA=20= >> RT 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&FONTNAMEs= dir=3D=20 >> as &VOLPKGNUMsort=3D[!] >> [/!]3&FONTNAMEsumm=3DT&startat=3D[startat]&max=3D[rslts]][founditems][s= ku] >> [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 =20 > > Web Archive of this list is at: http://webdna.smithmicro.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 Web Archive of this list is at: http://webdna.smithmicro.com/ Jon Young

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:

[BULK] [WebDNA] abstraction code can be tricky... (2012) [WebDNA] XML Parser (2016) How To question on setting up downloads (1997) Bookmarked URL with cart (1998) WebCat2 several catalogs? (1997) [WebDNA] [BULK] 7.x and 6.x on same server (2012) Install problems on 3.08 (2000) Opinion: [input] should be called [output] ... (1997) taxTotal, grandTotal (1997) Physical Proximity searches (2000) Separate SSL Server (1997) Additional Subtotals (1999) Fun with dates (1997) About WebDNA [well, and so the story ended] (2007) [WebDNA] Is the AutoCommit preference still supported? (2010) Off Topic: MacOS X Server on iMac (2000) [include ...] behavior (1997) emailer (1997) Retrospect Backup Misses Empty Folders (2000) Simple Page (2000)