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:

[BoldWords] WebCat.acgib15Mac (1997) WCS Newbie question (1997) Signal Raised Error (Part III) (1997) Sorting error (1997) WebCat Error Log problem (2.0.1, acgi, Mac) (1997) [WebDNA] Differences between WebDNA versions (2011) Webmerchant 2.1.3 startup questions, please (1999) [WebDNA] Grep out square brackets? (2010) NetSplat and WebCat2 (1997) How nuch ram??? (1997) [BULK] [WebDNA] Ubuntu 16.04 LTS & WebDNA (2017) Record size (1998) WebDNA on Intel Mac (2006) Up and running ... at last !! (1997) Re:Virtual hosting and webcatNT (1997) Rhapsody? (1997) [ShowIf] if the varieable exists (1998) Pithy questions on webcommerce & siteedit (1997) my price won't move (1997) New Command prefs ... (1997)