Re: Search results problem

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 48883
interpreted = N
texte = With that search, the only thing that it is searching for is eqVISIBLEdatarq=T.You're in effect setting a value to subarea by saying subarea equals ....etc. but it is not doing a comparison or search for anything related to subarea.You have to give it something to search for using the subarea variable:http://webdna.smithmicro.com/ref/pages.html?context=SearchWhatFor.htmlGK > Hi > > I have added a field to my database which just includes the area the product > is in > > When I search I get all the items in the database not just the ones in the > area I am searching > > I know this is a simple mistake somewhere but I cannot find it > > Basically I pass the variable subarea in the search but it is ignored > > code below > > Any help appreciated > > > [search > db=admin/products.db&max=[MAX_FOUNDITEMS]&startat=[start]&SKUsort=1&SKUsdir= > ra&eqVISIBLEdatarq=T&subarea=[url][subarea][/url]&[formvariables > name=--&exact=f][getchars > start=3][name][/getchars]=[url][value][/url]&[/formvariables]] > > THe variable [subarea] is being totally ignored but it is seen in the header > and also [subarea] on the page returns the correct info > > Thanks > Paul ------------------------------------------------------------- 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:

    
  1. Re: Search results problem (Gary Krockover 2003)
  2. Re: Search results problem (Erol Guneri 2003)
  3. Search results problem (Paul Berman 2003)
With that search, the only thing that it is searching for is eqVISIBLEdatarq=T.You're in effect setting a value to subarea by saying subarea equals ....etc. but it is not doing a comparison or search for anything related to subarea.You have to give it something to search for using the subarea variable:http://webdna.smithmicro.com/ref/pages.html?context=SearchWhatFor.htmlGK > Hi > > I have added a field to my database which just includes the area the product > is in > > When I search I get all the items in the database not just the ones in the > area I am searching > > I know this is a simple mistake somewhere but I cannot find it > > Basically I pass the variable subarea in the search but it is ignored > > code below > > Any help appreciated > > > [search > db=admin/products.db&max=[MAX_FOUNDITEMS]&startat=[start]&SKUsort=1&SKUsdir= > ra&eqVISIBLEdatarq=T&subarea=[url][subarea][/url]&[formvariables > name=--&exact=f][getchars > start=3][name][/getchars]=[url][value][/url]&[/formvariables]] > > THe variable [subarea] is being totally ignored but it is seen in the header > and also [subarea] on the page returns the correct info > > Thanks > Paul ------------------------------------------------------------- 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/ Gary Krockover

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:

search question (2001) WebCat2 several catalogs? (1997) SKU lookup (1997) SM: MySQL and Numbers (BUG) (2005) carriage returns in data (1997) AuthorizeNet SSL Update (2004) [subtotal] and others (1997) [WebDNA] Procedures to update to OSX Yosemite (2014) WebCat2b15MacPlugin - showing [math] (1997) Plugin or CGI or both (1997) Too Much Info (1998) cc auth with [purchase] (1998) Problems passing [SKU] with $Replace in 2.0 (1997) RE: strip .0 off off IPaddress (1999) Non-Cart Files in Shopping Cart Folder (1997) Simple way to create unique SKU (1997) Help with Shipping Costs (1997) WebCat2 - storing unformatted date data? (1997) WebCatalog can't find database (1997) emailer (1997)