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:
WebCatalog/WebMerchant Manuals Available (1998)
(1997)
Problem with empty form-variables in [search] (1998)
Using EIMS instead of Emailer (1998)
taxrate - off by 1 cent (1997)
Are you an WC expert? (1997)
Web Developer Product Awards (1997)
Re2: frames & carts (1997)
Adding Multiple Items to Shopping Cart from a Results page (1997)
Quick source question (2002)
Restricting templates from causing havoc (2000)
removing commas from a preformatted number (2000)
Modulo function? (2000)
Some Questions (1997)
Orderfile Encryption (2007)
Generating and appending SKU to a db automatically (1998)
[WebDNA] RESTART WebDNA (2016)
BGcolor (1997)
[taxRate] [TaxTotal] ? (1997)
Running _every_ page through WebCat ? (1997)