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:
Mac vs. Unix Line Endings (2002)
Search results templates (1996)
[WebDNA] Credit card processing (2012)
Pulling Captions from JPGs (2003)
Why WebDNA is not popular (2002)
Webcatalog quitting (1997)
$append (1998)
Emailer choke (1997)
Artwork (1997)
Bugs? What Bugs? was:Spawning Holdup? (2000)
[WebDNA] XML Help (2009)
Mac 2.1b4 unknown error: BadSuffix (1997)
lookup problem (2000)
[ConvertChars] problem (1997)
Sizes and colors (1999)
Protect vs Authenicate (1997)
Error Msg (1998)
Sort Order on a page search (1997)
list items (1998)
[ot] What'd you all get me for my birthday? ;) (2003)