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]RegardsStuart Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +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:
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]RegardsStuart Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +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)