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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Kenneth Grome
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...