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 ==20the table with other parameters other than LIDUPE, which simply has =20either an 'F' or 'T' in it's field. And [numfound]=3D0 is always zero. =so =20i'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:
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 ==20the table with other parameters other than LIDUPE, which simply has =20either an 'F' or 'T' in it's field. And [numfound]=3D0 is always zero. =so =20i'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)