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:
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)