Re: filtering [founditems]
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58627
interpreted = N
texte = Hi John, I don't have time to offer right now but I will caution you on your lack of use of "[url]". Any search values that might contain unfriendly characters... ie "&" and "[space]" etc.. need to be URLed. This is a first step (noting a bare [keyword] field)... to your question... treat a table as a database file. you can populate in a number of ways including using the database contexts.. replace etc.. You can populate it with syntax such as: [search] [table name=test&fields=one,two,three][!] [/!][founditems] [onedata] [twodata] [threedata] [/founditems][/table] [/search] Thats all I can offer right now. Donovan Jon Young wrote: > For Donovan (if available!) > > I read up on the [table] idea. Seems good for what I want to do. Here's > my code that is NOT working. How does one "feed" the first batch of > [founditems] to the table??? > > > > [search db=../../www.philsfonts.com/vault/philsfonts.db[!] > [/!][if > ("[key]"="4")][then]&eqFOCUSdatarq=[fcs]&eqFAMDISPdatarq=T[/then][!] > [/!][else]&[wrd]GROUP1datarq=[keyword]&GROUP1FIELD=nohtml+fontname+fampk > g+keywords+&eqFAMDISPdatarq=T[/else][/if][!] > [/!]&MANOPTsort=1&MANOPTtype=text&MANOPTsdir=de&FONTNAMEsort=2&FONTNAMEt > ype=text&FONTNAMEsdir=as&VOLPKGNUMsort=3&FONTNAMEsumm=T&startat=[startat > ]&max=[rslts]] > > > > > > > [table > name=liok&fields=SKU,FAMDISP,FAMPREFIX,FAMPKG,VOLPKGNUM,FONTPREFIX,FONTN > AME,KEYWORDS,PRINTERNAME,PKGPRICE,PRICE,CLASSIFICATION,DESIGNER,FOUNDRY, > FOUNDRYCODE,PARENTROOT,SORTORDER,MISCINFO,ORIGCLASS,PKGONLY,ORIGDESIGNER > ,ORIGFOUNDRY,ORIGFOUNDRYCODE,ORIGVOLPKG,ORIGPARTNUM,TAXABLE,DOWNLOAD,MAN > OPT,FOCUS,NOHTML,GLNUM,LIDUPE] > [founditems][/founditems][/search] > [/table] > > > > [search table=liok&eqLIDUPEdatarq=F] > > > -- -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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:
Hi John, I don't have time to offer right now but I will caution you on your lack of use of "[url]". Any search values that might contain unfriendly characters... ie "&" and "[space]" etc.. need to be URLed. This is a first step (noting a bare [keyword] field)... to your question... treat a table as a database file. you can populate in a number of ways including using the database contexts.. replace etc.. You can populate it with syntax such as: [search] [table name=test&fields=one,two,three][!] [/!][founditems] [onedata] [twodata] [threedata] [/founditems][/table] [/search] Thats all I can offer right now. Donovan Jon Young wrote: > For Donovan (if available!) > > I read up on the [table] idea. Seems good for what I want to do. Here's > my code that is NOT working. How does one "feed" the first batch of > [founditems] to the table??? > > > > [search db=../../www.philsfonts.com/vault/philsfonts.db[!] > [/!][if > ("[key]"="4")][then]&eqFOCUSdatarq=[fcs]&eqFAMDISPdatarq=T[/then][!] > [/!][else]&[wrd]GROUP1datarq=[keyword]&GROUP1FIELD=nohtml+fontname+fampk > g+keywords+&eqFAMDISPdatarq=T[/else][/if][!] > [/!]&MANOPTsort=1&MANOPTtype=text&MANOPTsdir=de&FONTNAMEsort=2&FONTNAMEt > ype=text&FONTNAMEsdir=as&VOLPKGNUMsort=3&FONTNAMEsumm=T&startat=[startat > ]&max=[rslts]] > > > > > > > [table > name=liok&fields=SKU,FAMDISP,FAMPREFIX,FAMPKG,VOLPKGNUM,FONTPREFIX,FONTN > AME,KEYWORDS,PRINTERNAME,PKGPRICE,PRICE,CLASSIFICATION,DESIGNER,FOUNDRY, > FOUNDRYCODE,PARENTROOT,SORTORDER,MISCINFO,ORIGCLASS,PKGONLY,ORIGDESIGNER > ,ORIGFOUNDRY,ORIGFOUNDRYCODE,ORIGVOLPKG,ORIGPARTNUM,TAXABLE,DOWNLOAD,MAN > OPT,FOCUS,NOHTML,GLNUM,LIDUPE] > [founditems][/founditems][/search] > [/table] > > > > [search table=liok&eqLIDUPEdatarq=F] > > > -- -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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/
Donovan Brooke
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:
quantity minimum problem (1997)
shared_POP and archiving your own mailing list (2003)
WebCat & WebTen (1997)
Snake Bites (1997)
Searching multiple fields from one form field (1997)
Problems passing [SKU] with $Replace in 2.0 (1997)
Comments in db? (1997)
EIMS Problems (1997)
Auth.net and SIM (2003)
Interfacing WebMerchant to www.fedex.com (1997)
[username][password] not showing up. (2000)
Listserver problem (1997)
Register First (2000)
virtual virtual hosted store.... (1998)
triggers.db (1999)
PSC recommends what date format yr 2000??? (1997)
[url] (1997)
[isfile] ? (1997)
cart ID (1998)
RE: Can't get appendfile to work (1997)