Re: combine search

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16313
interpreted = N
texte = >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: > >Pretty basic: > >Search: > > > > >Result page: > >[search db=xxxx.db&woareaCodedatarq=[ac1],[ac2],[ac3]] > >This is very basic and there is more code than what is listed... But I have >narrowed the problem down to this. > >I think WC is interpreting the ac1..ac3 variables as spaces, therefore the >actual input is not blank and it actually looks for the spaces? I am not >sure what is going on here. HELP! I don't think it's looking for blank spaces ...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 course), and that will force WebCat to return all the records when nothing is entered into those areaCode fields ... :)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:

    
  1. Re: combine search (Kenneth Grome 1998)
  2. Re: combine search (APC Home PC 1998)
  3. Re: combine search (Kenneth Grome 1998)
  4. combine search (APC Home PC 1998)
>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: > >Pretty basic: > >Search: > > > > >Result page: > >[search db=xxxx.db&woareaCodedatarq=[ac1],[ac2],[ac3]] > >This is very basic and there is more code than what is listed... But I have >narrowed the problem down to this. > >I think WC is interpreting the ac1..ac3 variables as spaces, therefore the >actual input is not blank and it actually looks for the spaces? I am not >sure what is going on here. HELP! I don't think it's looking for blank spaces ...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 course), and that will force WebCat to return all the records when nothing is entered into those areaCode fields ... :)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:

[WebDNA] Strange happenings (2012) [WebDNA] convert time stamp back (2010) Authentication (1998) Trouble with formula.db + more explanation (1997) View order not right (1997) expired beta (1997) grep for search, not replace (2002) ReadDateFormat bug in 3.0.1 (1998) Search problem C++ (2000) Kaaaaahhhhhhhnnnnnnn! (1997) Weird bug, or is there something amiss? (1997) Another question about credit cards (1997) unsubscribe (1997) WebCat2 several catalogs? (1997) message forum question (2005) Almost a there but..bye bye NetCloak (1997) PCS Emailer's role ? (1997) Search in 2 or more catalogs (1997) re: Large databases in WebCat (1997) OT - How to pay commissions to non US affiliates? (2000)