Re: combine search

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16316
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] Same result... I have changed my search page and specified to the user to put a space between each areacode to search for. That works... Below: <Area Code(s):<
<<(ex: 305 954 561)<<<<<< On my result page here is my search context:[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. On a another subject: Why must I keep the [search] contents on the same line in my text editor. (I have used w95 word pad (txt file save) and notepad same result). It's really annoying because of the long lines. If I go beyond the 1st line of text in the [search it will not interpret the 2nd line....
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)
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] Same result... I have changed my search page and specified to the user to put a space between each areacode to search for. That works... Below: <Area Code(s):<
<<(ex: 305 954 561)<<<<<< On my result page here is my search context:[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. On a another subject: Why must I keep the [search] contents on the same line in my text editor. (I have used w95 word pad (txt file save) and notepad same result). It's really annoying because of the long lines. If I go beyond the 1st line of text in the [search it will not interpret the 2nd line....
APC Home PC

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:

RE: ShowNext Command (1997) Dummy Credit Card Number for debug? (1997) lookup and two records? (1997) Listserver problem (1997) [shownext max=?] armed (1997) WebCat and search engines (1998) Loss in Form (1998) [OT] Google Info (2004) Problems getting parameters passed into email. (1997) carriage returns in data (1997) ImageMap (1997) Problems appending to database (1997) docs for WebCatalog2 (1997) [WebDNA] Migration from 6.2 to 7. Problems with writing to DB's (2012) date formatting for CC card expiration date check (1998) Random (2000) Merry Christmas! :) (1998) old cart file deletion (2000) Creditcard verification with WebCat (1998) No luck with taxes (1997)