Re: HELP! Search finding too much!
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20310
interpreted = N
texte = >>>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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>>>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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Kenneth Grome
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:
Mac Vs WindowsNT (1997)
Grepping a csv (2003)
WCS Newbie question (1997)
Quick Question (1997)
email servers (2000)
read and write you own cookies with webcat (1997)
Newbie from and old bee (1997)
Classified Ads 4 Sale (1998)
WebCatalog can't find database (1997)
Summ=T Problem (1997)
Another IfThenElse question.. (2003)
Dealing with da back button (1999)
authenticate broken when url not fully specified? (2000)
creator code (1997)
Getting Total Quantity (1997)
RE: Dates! (1998)
Calculate QTY (1998)
Credit Card Number checking (1997)
OT: Sending email to lots of subscribers (1999)
[WebDNA] How to create a MD5 hash & decrypt it (2011)