searching with if/then

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 57997
interpreted = N
texte = Hello all, First post ever! Anybody know why the heck this isn't working... I can explain more if needed: [search db=../../www.philsfonts.com/vault/philsfonts.db[!] [/!][showif [keyword]!]&[wrd]GROUP1datarq=[keyword]&GROUP1FIELD=[!] [/!][If(([fontsrch]=T)&([famsrch]=T))][Then]nohtml+fontname+foundry+famp kg+[/Then][/If][!] [/!][If(([fontsrch]=T)&([famsrch]=F))][Then]nohtml+fontname+foundry+famp kg+[/Then][/If][!] [/!][If(([fontsrch]=F)&([famsrch]=T))][Then]&eqFAMDISPdatarq=T[/Then][/ If][!] [/!][If(([fontsrch]=F)&([famsrch]=F))][Then][math show=F]err=0,err_num=0[/math][/Then][/If][!] [/!][showif [foundrystring]!]&woFOUNDRYdatarq=[foundrystring]&FOUNDRYword=sw&FOUNDRY wbrk=,[/showif][!] [/!][showif [designer]!]&eqDESIGNERdatarq=[designer][/showif][!] [/!][showif [classstring]!]&woCLASSIFICATIONdatarq=[classstring]&CLASSIFICATIONword= sw&CLASSIFICATIONwbrk=,[/showif][!] [/!]&MANOPTsort=1&MANOPTtype=text&MANOPTsdir=de&FONTNAMEsort=2&FONTNAMEt ype=text&FONTNAMEsdir=as&VOLPKGNUMsort=3&FONTNAMEsumm=T&startat=[startat ]&max=[rslts]][/showif][/search] Not sure if this is the right way to phrase this but... we're trying to assign the different search parameters with various if/then conditional statements and some [showif]'s. Not working. When we try to access the [founditems] later on in the code, it's telling me it can't because there is no search context. This was an experiment. So it may be way off. Just thought I'd check. Thanks for any help! Jon -- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: searching with if/then ( Gary Krockover 2004)
  2. Re: searching with if/then ( Stuart Tremain 2004)
  3. Re: searching with if/then ( "Sal" 2004)
  4. Re: searching with if/then ( Brian Fries 2004)
  5. Re: searching with if/then ( Jon Young 2004)
  6. Re: searching with if/then ( Stuart Tremain 2004)
  7. searching with if/then ( Jon Young 2004)
Hello all, First post ever! Anybody know why the heck this isn't working... I can explain more if needed: [search db=../../www.philsfonts.com/vault/philsfonts.db[!] [/!][showif [keyword]!]&[wrd]GROUP1datarq=[keyword]&GROUP1FIELD=[!] [/!][If(([fontsrch]=T)&([famsrch]=T))][Then]nohtml+fontname+foundry+famp kg+[/Then][/If][!] [/!][If(([fontsrch]=T)&([famsrch]=F))][Then]nohtml+fontname+foundry+famp kg+[/Then][/If][!] [/!][If(([fontsrch]=F)&([famsrch]=T))][Then]&eqFAMDISPdatarq=T[/Then][/ If][!] [/!][If(([fontsrch]=F)&([famsrch]=F))][Then][math show=F]err=0,err_num=0[/math][/Then][/If][!] [/!][showif [foundrystring]!]&woFOUNDRYdatarq=[foundrystring]&FOUNDRYword=sw&FOUNDRY wbrk=,[/showif][!] [/!][showif [designer]!]&eqDESIGNERdatarq=[designer][/showif][!] [/!][showif [classstring]!]&woCLASSIFICATIONdatarq=[classstring]&CLASSIFICATIONword= sw&CLASSIFICATIONwbrk=,[/showif][!] [/!]&MANOPTsort=1&MANOPTtype=text&MANOPTsdir=de&FONTNAMEsort=2&FONTNAMEt ype=text&FONTNAMEsdir=as&VOLPKGNUMsort=3&FONTNAMEsumm=T&startat=[startat ]&max=[rslts]][/showif][/search] Not sure if this is the right way to phrase this but... we're trying to assign the different search parameters with various if/then conditional statements and some [showif]'s. Not working. When we try to access the [founditems] later on in the code, it's telling me it can't because there is no search context. This was an experiment. So it may be way off. Just thought I'd check. Thanks for any help! Jon -- 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 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:

WebCatalog2 Feature Feedback (1996) re: [addlineitem] working almost (1997) webcat- multiple selection in input field (1997) Practice runs ? (1997) price carry over (1997) Database alias & long filename question (2001) Cleaner URLs (2003) Multiple prices (1997) problems with 2 tags (1997) Sku numbers (1997) Great product and great job ! (1997) Grouping fields help (2004) multi-paragraph fields (1997) passing cart value (2003) apostrophe in search item (1997) [WebDNA] why this error when using [shownext] with a [table]? (2009) Where is f2? (1997) August 15th WebDNA Chat Transcript (2002) Upgrading old WebCat Database Files (1997) calculating tax rates, mail order solutions and version 2 (1997)