Re: combine search
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16326
interpreted = N
texte = >At 08:57 PM 2/26/98 -0800, you wrote: >>>I am attempting to search a classifieds style database. I want to give the >>>user a way to enter 3 different area codes in which to narrow there search. >>>If no data is enter in the 3 fields or no matching data is entered, the >>>search result is always 0 records. From what I understand, webcatalog >>>should ignore the field and return all records. below is a sample of my >>>input search and my result page: >>> >>Here, try the same search *without* the rq on the end of the woareaCodedatarq parameter and see what happens. If that doesn't fix it, add another parameter such as &neskudatarq=[blank] (assuming that you have a field in the database named sku of >> > >I have tried it without the rq and it has the same result. >I have also tried a line context such as: > >[search db=xxxx.db&woareaCodedatarq=&descriptiondatard=Dusky]This search will retrieve only the records with Dusky in the description, it will never retrieve all the records ... unless they all have Dusky in the description ... :)>I have changed my search page and specified to the user to put a space between each areacode to search for.I thought you had three separate text fields to collect your area codes? So now you've combined them and allow users to enter the area codes into a single field, is that it?>On my result page here is my search context that works... : >[search db=marine.db&AllReqd=T&wotypedata=[form.type]&rnlengthdata=[form.length]&rnpricedata=[form.price]&geiddata=0&group1field=mfg+model+description&wogroup1data=[form.keyword]&woareaCodedata=[form.areaCode]] > >Oh yea I do have a geiddata=0. id comes from [cart] when a record is appended.Well if that geiddata=0 parameter was *not* in your previous search context, then that's the thing that changed your results and is now making your search return ALL the records when no area codes are entered.That additional parameter does exactly the same thing as the &neskudatarq=[blank] would have done in my previous suggestion -- provided you actually had a field named SKU in your database AND provided that every record had some kind of value in that field instead of being [blank] ... :)Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Associated Messages, from the most recent to the oldest:
>At 08:57 PM 2/26/98 -0800, you wrote: >>>I am attempting to search a classifieds style database. I want to give the >>>user a way to enter 3 different area codes in which to narrow there search. >>>If no data is enter in the 3 fields or no matching data is entered, the >>>search result is always 0 records. From what I understand, webcatalog >>>should ignore the field and return all records. below is a sample of my >>>input search and my result page: >>> >>Here, try the same search *without* the rq on the end of the woareaCodedatarq parameter and see what happens. If that doesn't fix it, add another parameter such as &neskudatarq=[blank] (assuming that you have a field in the database named sku of >> > >I have tried it without the rq and it has the same result. >I have also tried a line context such as: > >[search db=xxxx.db&woareaCodedatarq=&descriptiondatard=Dusky]This search will retrieve only the records with Dusky in the description, it will never retrieve all the records ... unless they all have Dusky in the description ... :)>I have changed my search page and specified to the user to put a space between each areacode to search for.I thought you had three separate text fields to collect your area codes? So now you've combined them and allow users to enter the area codes into a single field, is that it?>On my result page here is my search context that works... : >[search db=marine.db&AllReqd=T&wotypedata=[form.type]&rnlengthdata=[form.length]&rnpricedata=[form.price]&geiddata=0&group1field=mfg+model+description&wogroup1data=[form.keyword]&woareaCodedata=[form.areaCode]] > >Oh yea I do have a geiddata=0. id comes from
[cart] when a record is appended.Well if that geiddata=0 parameter was *not* in your previous search context, then that's the thing that changed your results and is now making your search return ALL the records when no area codes are entered.That additional parameter does exactly the same thing as the &neskudatarq=[blank] would have done in my previous suggestion -- provided you actually had a field named SKU in your database AND provided that every record had some kind of value in that field instead of being [blank] ... :)Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://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:
DON'T use old cart file! (1997)
Credit card processing - UK (1997)
Emailer 1.01 bombs (1997)
Cart Question (1998)
Email notification to one of multiple vendors ? (1997)
Browser Check for WebDNA compatability (1999)
OT: webstar/webcat monitoring aides? (1999)
Calendar Program (2004)
2nd WebCatalog2 Feature Request (1996)
absolute paths for databases? (1997)
New Plug-in and Type 11 errors (1997)
[WebDNA] Format Days_To_Date (2008)
Whats going on with my SERIAL NUMBER??? (1998)
WebCatalog NT beta 18 problem (1997)
Performance Settings (2000)
Buying sans cart (1997)
grep question - removing spaces (2005)
Locking up with WebCatalog... (1997)
[Semi-OT] Eaaaaaasy OSX FTP (2003)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)