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:

Processing all html files through WebCat or Typhoon (1998) wc 2 pro users - sites, quotes wanted (1997) Set Header Context (1998) Only charge card when product shipped ? (1997) WebDNA-Talk Digests (1997) Return records from another (1997) bulletin board (2002) Bug Report, maybe (1997) Caching [include] files ... (1997) WebCat2b12 CGI Mac - [shownext] problem (1997) WebCatalog v2.1.1 (1998) WCS Newbie question (1997) ConverChars (1999) suggestions needed for shipping cost solution (1999) how do ye do this?????? (2001) can you reassign loop index? (1998) Re:quit command on NT (1997) Format 1.15 to 1:15:00 or 01:15:00 (2002) RE: AccountAuthorizer doesn't seem to work (1997) db access problem after switching to SSL (2001)