Re: [WebDNA] hideif within a search
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 103126
interpreted = N
texte = Rich Kwas wrote:> I have a search where 2 choices are made from dropdowns.> > Item 1 is a category.> Item 2 lists a website where reviews might be found for listings within that category.> > There currently are 8 choices as well as "All" for that second Item.> > Item 2 is written like this within the db:> +3+50+51+> and so on depending on the site ID etc> > > To show results for "All" as the 2nd choice I've inserted a [hideif] within the search:> > [Search db=^/ihr/ihr.db&eqVisibleDatarq=T&eqPreferredDatarq=No&woSECTIONSdatarq=[cat]&SECTIONSword=ww&namewbrk=+&SKUsort=1&SKUsdir=ra&allhit=1[hideif [reviewsites]=All]&woReviewSitesdatarq=[ReviewSites]&ReviewSitesword=ww&ReviewSiteswbrk=+[/hideif]]> > > This seems to be working fine, but I've never placed a hideif within a search in the past> > > My question.....> Is placing a [hideif] within a search acceptable?> > ...if not is there as easier way to find "All" if indicated in that second Item?> > > I'm using 6.0 on IIS.......> > > ThanksHi Rich, sure, hideif's and any other code are just fine in there... however, you may benefit from the convention of setting a tSearchCriteria variable as follows:[switch value=[tReviewSites]] [case value=ALL] [text]tSearchCriteria=blah blah blah[/text] [/case] [default] [text]tSearchCriteria=Default blah blah[/text] [/default][/switch]Then in the search:[search db=^/your/db.db&[tSearchCriteria]]lastly, depending on what possible values are in [cat] and [reviewsites].. you may want to consider wrapping them in [url][/url]'s in your search criteria.DonovanDonovan BrookeWebDNA Software Corporationhttp://www.webdna.us**[Square Bracket Utopia]**
Associated Messages, from the most recent to the oldest:
Rich Kwas wrote:> I have a search where 2 choices are made from dropdowns.> > Item 1 is a category.> Item 2 lists a website where reviews might be found for listings within that category.> > There currently are 8 choices as well as "All" for that second Item.> > Item 2 is written like this within the db:> +3+50+51+> and so on depending on the site ID etc> > > To show results for "All" as the 2nd choice I've inserted a
[hideif] within the search:> > [Search db=^/ihr/ihr.db&eqVisibleDatarq=T&eqPreferredDatarq=No&woSECTIONSdatarq=[cat]&SECTIONSword=ww&namewbrk=+&SKUsort=1&SKUsdir=ra&allhit=1[hideif [reviewsites]=All]&woReviewSitesdatarq=[ReviewSites]&ReviewSitesword=ww&ReviewSiteswbrk=+[/hideif]]> > > This seems to be working fine, but I've never placed a hideif within a search in the past> > > My question.....> Is placing a
[hideif] within a search acceptable?> > ...if not is there as easier way to find "All" if indicated in that second Item?> > > I'm using 6.0 on IIS.......> > > ThanksHi Rich, sure, hideif's and any other code are just fine in there... however, you may benefit from the convention of setting a tSearchCriteria variable as follows:[switch value=[tReviewSites]] [case value=ALL]
[text]tSearchCriteria=blah blah blah[/text] [/case] [default]
[text]tSearchCriteria=Default blah blah[/text] [/default][/switch]Then in the search:[search db=^/your/db.db&[tSearchCriteria]]lastly, depending on what possible values are in [cat] and [reviewsites].. you may want to consider wrapping them in
[url][/url]'s in your search criteria.DonovanDonovan BrookeWebDNA Software Corporationhttp://www.webdna.us**[Square Bracket Utopia]**
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:
Interfacing WebMerchant to www.fedex.com (1997)
FW: Shipping calculations (1997)
E-Mailer (WebCatb15acgiMac) (1997)
Formvariable won't update (1999)
WebCat2: multiple currency support (1997)
PCS Customer submissions ? (1997)
Encrypting WebDNA Templates and eligible files (1999)
Emailer Problem (1998)
Shared Webstar Directory (1998)
Malformed Pages (1999)
Re[2]: Base64 encryption limitations? (1999)
WebCat2b12--[searchstring] bug (1997)
How many Databases can I open? (2003)
Unformatted Messages (1998)
Webcat causing crashes left and right! (1997)
Need formum software... (2003)
[showif [getcookie otherDomain]=yes] inside a [TCP connect] will work? (2000)
CustomerType - WebDNA Variable (2004)
japanese characters (1997)
PCS Frames (1997)