Re: HELP! Search finding too much!
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19879
interpreted = N
texte = Kenneth Grome wrote: > > >>>I am trying to find items only in the Category Jewelry yet when I > >>>create this tag - > >>> > >>>jewelry.tmpl$search?db=../chef.db&geskudata=0&cart=[cart]&searchCategory=Jewelry&SKUsort=1&SKUsdir=de > >>> > >>>I get the jewelry items (19 of them) listed within the format set in > >>>jewelry.tmpl, > >>>but then it adds ALL the other items from the chef.db below!! > >>> > >>>Can someone help me keep all the non-jewelry items out of the search > >>>results? > >> > >> > >> Hi Jim, > >> Welcome to WebCatalog! > >> Here, try this instead: > >> > >> jewelry.tmpl?cart=[cart]&command=search&db=../chef.db&eqCategorydata=Jewelry&deSKUsort=1 > > > > > >Ken: > >Try changing the name of the database ../chef.db to something else > >like jewelry.db and see if that helps. > > There is no reason to change the database name, it is the correct database reference. Jim was getting the proper records from that db, so it is indeed the correct db. It seems clear to me that the search parameters were causing the wrong results to be returned, thus my reason for suggesting a URL with the correct parameters ... :) > > Sincerely, > Ken Grome > 808-737-6499 > WebDNA Solutions > mailto:ken@webdna.net > http://www.webdna.net Your right because he was trying to search the sku and Category fields at the same time, but I thought by the way the post was written he had a database named ../chef.db AND chef.db. This should answer his question as to why searchCategory=Jewelry worked as before he was searching two fields. I should have looked at the linking better, sorry..
Associated Messages, from the most recent to the oldest:
Kenneth Grome wrote: > > >>>I am trying to find items only in the Category Jewelry yet when I > >>>create this tag - > >>> > >>>jewelry.tmpl$search?db=../chef.db&geskudata=0&cart=
[cart]&searchCategory=Jewelry&SKUsort=1&SKUsdir=de > >>> > >>>I get the jewelry items (19 of them) listed within the format set in > >>>jewelry.tmpl, > >>>but then it adds ALL the other items from the chef.db below!! > >>> > >>>Can someone help me keep all the non-jewelry items out of the search > >>>results? > >> > >> > >> Hi Jim, > >> Welcome to WebCatalog! > >> Here, try this instead: > >> > >> jewelry.tmpl?cart=
[cart]&command=search&db=../chef.db&eqCategorydata=Jewelry&deSKUsort=1 > > > > > >Ken: > >Try changing the name of the database ../chef.db to something else > >like jewelry.db and see if that helps. > > There is no reason to change the database name, it is the correct database reference. Jim was getting the proper records from that db, so it is indeed the correct db. It seems clear to me that the search parameters were causing the wrong results to be returned, thus my reason for suggesting a URL with the correct parameters ... :) > > Sincerely, > Ken Grome > 808-737-6499 > WebDNA Solutions > mailto:ken@webdna.net > http://www.webdna.net Your right because he was trying to search the sku and Category fields at the same time, but I thought by the way the post was written he had a database named ../chef.db AND chef.db. This should answer his question as to why searchCategory=Jewelry worked as before he was searching two fields. I should have looked at the linking better, sorry..
searchmaster@databot.com
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:
notification solutions (1997)
Mailer (2006)
How to Display text in empty fields (1997)
Include error (2000)
anyone know how to set header for XML/RSS files? (2008)
Banners and sort of random display (1997)
b12 cannot limit records returned and more. (1997)
More on the email templates (1997)
File Upload (1997)
[WriteFile] problems (1997)
[WebDNA] [thisurl] not clean on fastcgi 7 (2010)
Multiple Pulldowns/Gary (1997)
Date conversion (2002)
[WebDNA] filter out the exclaimation point (2017)
Req: Array Tags Explained, simple and clear (2004)
[include] error message (was:how to put/keep product customization info in basket?) (1998)
Sku numbers (1997)
multi-paragraph fields (1997)
[WebDNA] Not even sure what to ask for help on. . . :( (2008)
no [search] with NT (1997)