Re: searching with if/then

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 57998
interpreted = N
texte = Try this: [search db=../../www.philsfonts.com/vault/philsfonts.db[!] [/!][showif [URL][keyword][/URL]!]&[wrd]GROUP1datarq=[keyword]&GROUP1FIELD=[!] [/!][If(("[fontsrch]"="T")&("[famsrch]"="T"))][Then]nohtml+fontname+foun dry+fampkg+[/Then][/If][!] [/!][If(("[fontsrch]"="T")&("[famsrch]"="F"))][Then]nohtml+fontname+foun dry+fampkg+[/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 [URL][foundrystring][/ URL]!]&woFOUNDRYdatarq=[foundrystring]&FOUNDRYword=sw&FOUNDRYwbrk=,[/ showif][!] [/!][showif [URL][designer][/URL]!]&eqDESIGNERdatarq=[designer][/showif][!] [/!][showif [URL][classstring][/ URL]!]&woCLASSIFICATIONdatarq=[classstring]&CLASSIFICATIONword=sw&CLASSI FICATIONwbrk=,[/showif][!] [/!]&MANOPTsort=1&MANOPTtype=text&MANOPTsdir=de&FONTNAMEsort=2&FONTNAMEt ype=text&FONTNAMEsdir=as&VOLPKGNUMsort=3&FONTNAMEsumm=T&startat=[startat ]&max=[rslts]][/showif][/search] Put URL around your showifs and " in your Ifs as you are doing a Text comparison you must declare it to be text by using " On 25 May 2004, at 09:57 AM, Jon Young wrote: > [search db=../../www.philsfonts.com/vault/philsfonts.db[!] > [/!][showif [keyword]!]&[wrd]GROUP1datarq=[keyword]&GROUP1FIELD=[!] > [/!][If(([fontsrch]=T)&([famsrch]=T))][Then]nohtml+fontname+foundry+fam > pkg+[/Then][/If][!] > [/!][If(([fontsrch]=T)&([famsrch]=F))][Then]nohtml+fontname+foundry+fam > pkg+[/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&FOUNDR > Ywbrk=,[/showif][!] > [/!][showif [designer]!]&eqDESIGNERdatarq=[designer][/showif][!] > [/!][showif > [classstring]!]&woCLASSIFICATIONdatarq=[classstring]&CLASSIFICATIONword > =sw&CLASSIFICATIONwbrk=,[/showif][!] > [/!]&MANOPTsort=1&MANOPTtype=text&MANOPTsdir=de&FONTNAMEsort=2&FONTNAME > type=text&FONTNAMEsdir=as&VOLPKGNUMsort=3&FONTNAMEsumm=T&startat=[start > at]&max=[rslts]][/showif][/search] Regards Stuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 ------------------------------------------------------------- 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)
Try this: [search db=../../www.philsfonts.com/vault/philsfonts.db[!] [/!][showif [url][keyword][/URL]!]&[wrd]GROUP1datarq=[keyword]&GROUP1FIELD=[!] [/!][If(("[fontsrch]"="T")&("[famsrch]"="T"))][Then]nohtml+fontname+foun dry+fampkg+[/Then][/If][!] [/!][If(("[fontsrch]"="T")&("[famsrch]"="F"))][Then]nohtml+fontname+foun dry+fampkg+[/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 [url][foundrystring][/ URL]!]&woFOUNDRYdatarq=[foundrystring]&FOUNDRYword=sw&FOUNDRYwbrk=,[/ showif][!] [/!][showif [url][designer][/URL]!]&eqDESIGNERdatarq=[designer][/showif][!] [/!][showif [url][classstring][/ URL]!]&woCLASSIFICATIONdatarq=[classstring]&CLASSIFICATIONword=sw&CLASSI FICATIONwbrk=,[/showif][!] [/!]&MANOPTsort=1&MANOPTtype=text&MANOPTsdir=de&FONTNAMEsort=2&FONTNAMEt ype=text&FONTNAMEsdir=as&VOLPKGNUMsort=3&FONTNAMEsumm=T&startat=[startat ]&max=[rslts]][/showif][/search] Put URL around your showifs and " in your Ifs as you are doing a Text comparison you must declare it to be text by using " On 25 May 2004, at 09:57 AM, Jon Young wrote: > [search db=../../www.philsfonts.com/vault/philsfonts.db[!] > [/!][showif [keyword]!]&[wrd]GROUP1datarq=[keyword]&GROUP1FIELD=[!] > [/!][If(([fontsrch]=T)&([famsrch]=T))][Then]nohtml+fontname+foundry+fam > pkg+[/Then][/If][!] > [/!][If(([fontsrch]=T)&([famsrch]=F))][Then]nohtml+fontname+foundry+fam > pkg+[/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&FOUNDR > Ywbrk=,[/showif][!] > [/!][showif [designer]!]&eqDESIGNERdatarq=[designer][/showif][!] > [/!][showif > [classstring]!]&woCLASSIFICATIONdatarq=[classstring]&CLASSIFICATIONword > =sw&CLASSIFICATIONwbrk=,[/showif][!] > [/!]&MANOPTsort=1&MANOPTtype=text&MANOPTsdir=de&FONTNAMEsort=2&FONTNAME > type=text&FONTNAMEsdir=as&VOLPKGNUMsort=3&FONTNAMEsumm=T&startat=[start > at]&max=[rslts]][/showif][/search] Regards Stuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 ------------------------------------------------------------- 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/ Stuart Tremain

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:

2nd WebCatalog2 Feature Request (1996) Cancel Subscription (1996) Tab Delimited Files / FM Pro (1997) remotely add + sign (1997) [WebDNA] CICADA (2009) 3 card formulas! (1999) old problem (2001) random prob (2003) can WC render sites out? (1997) [WebDNA] Clean URLS job - will pay (2010) problems with 2 tags shakur (1997) Random ads (1998) WebCommerce: Folder organization ? (1997) File Upload (1997) order in the search? (2003) How to display images? (2002) Not really WebCat (1997) Convert Chars Issue? (2000) problems with WebCat-Plugin (1997) What does this error mean? (2000)