Re: searching with if/then
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58013
interpreted = N
texte = Jon Young wrote:> Hello all,> > First post ever!> > Anybody know why the heck this isn't working... I can explain more if > needed:[snip]Jon, welcome to the group. The problem I have with new posters postingcomplex search perams is first, that there are many problems and it takes timeto point everything out. Second, I don't know of all the vast possible valuesthat could be going into the context so it is just about hopeless to troubleshoot. I am not sure how to suggest a better post... maybe taking out non-issueperams such as sort etc... maybe including value examples above the search..such as:Value examples:[fontsrch] = "san-serif"[fontfam] = "helvetica"[keyword] = "puff daddy"etc..However, here is some comments towards the revised (stuarts) code:Lots of questions:[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]Cheers,Donovan-- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------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:
Jon Young wrote:> Hello all,> > First post ever!> > Anybody know why the heck this isn't working... I can explain more if > needed:[snip]Jon, welcome to the group. The problem I have with new posters postingcomplex search perams is first, that there are many problems and it takes timeto point everything out. Second, I don't know of all the vast possible valuesthat could be going into the context so it is just about hopeless to troubleshoot. I am not sure how to suggest a better post... maybe taking out non-issueperams such as sort etc... maybe including value examples above the search..such as:Value examples:[fontsrch] = "san-serif"[fontfam] = "helvetica"[keyword] = "puff daddy"etc..However, here is some comments towards the revised (stuarts) code:Lots of questions:[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]Cheers,Donovan-- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------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/
Donovan Brooke
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:
$quit / Command=Quit (2002)
WebCatalog plugin, FireSite and PIXO (2000)
A quickie question (1997)
Requiring that certain fields be completed (1997)
WebCommerce: Folder organization ? (1997)
One more try (1997)
New One (for me).... Error type 12 (1999)
Webcatalog quitting (1997)
Sorting when searching with grouped fields (2002)
Secure Server basic question... (1997)
Claris HomePage messes up the code (1997)
My solution... (1996)
WebCatalog NT beta 18 now available (1997)
WebCatalog and Macromedia Flash (1998)
Help name our technology! (1997)
[date] problem with %d%m%Y (1998)
HomePage Caution (1997)
Problems with ^ could be solved with [REPLACE CHARACTERS] (1997)
RE: [WebDNA] [OT] Apple iPad (2010)
No luck with taxes (1997)