Re: Searching Numbers
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58649
interpreted = N
texte = If you're comparing a 5 digit zip code to values in the database that are stored as 12345 12345, then you wont get a match since they don't (fully) equal one another. I don't think a wo search is going to work as one of the "or" words has to match and again, the 5 digit zip isn't going to match the 5 digit space 5 digit value. Try it, but don't think it will work. You might look at trying: close to (numeric only). clZipCodedatarq=92069&clZipCodedata=10 finds all records whose ZipCode field is within 10 of 92069 (92059 - 92079) begins with (bw). If the 5 digit code always matches the first 5 digits that are stored in the db, this would work. If you might match on the 2nd set of digits, then this wont work. The best option, if possible, would be to break those 5 digit splits into two separate fields. You could then do a range search: rnStoreZipCodedatarq=[lowzip] [highzip]&StoreZipCodedatatype=num It would be pretty easy to write some WebDNA that would split those up for you in one swoop while writing to another database that you could then swap out for the one you have now. Look into using [listwords] to handle that for you. GK At 11:30 PM 6/27/2004, you wrote: >Thanks Gary, the spaces are email related. > >I tried the [url] tags around the search, but still come up with the >same problems. The 5 digit zip code doesn't seem to find the records. >We have entered the zip codes into one field thinking that the values >would behave as words. > >[search >db=admin/stores/ >stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[url][zipstore][/ >url]&StoreZipCodetype=num] > >Should I consider a wo search like a keyword search instead of a data >lookup? > >David ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
If you're comparing a 5 digit zip code to values in the database that are stored as 12345 12345, then you wont get a match since they don't (fully) equal one another. I don't think a wo search is going to work as one of the "or" words has to match and again, the 5 digit zip isn't going to match the 5 digit space 5 digit value. Try it, but don't think it will work. You might look at trying: close to (numeric only). clZipCodedatarq=92069&clZipCodedata=10 finds all records whose ZipCode field is within 10 of 92069 (92059 - 92079) begins with (bw). If the 5 digit code always matches the first 5 digits that are stored in the db, this would work. If you might match on the 2nd set of digits, then this wont work. The best option, if possible, would be to break those 5 digit splits into two separate fields. You could then do a range search: rnStoreZipCodedatarq=[lowzip] [highzip]&StoreZipCodedatatype=num It would be pretty easy to write some WebDNA that would split those up for you in one swoop while writing to another database that you could then swap out for the one you have now. Look into using [listwords] to handle that for you. GK At 11:30 PM 6/27/2004, you wrote: >Thanks Gary, the spaces are email related. > >I tried the [url] tags around the search, but still come up with the >same problems. The 5 digit zip code doesn't seem to find the records. >We have entered the zip codes into one field thinking that the values >would behave as words. > >[search >db=admin/stores/ >stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[url][zipstore][/ >url]&StoreZipCodetype=num] > >Should I consider a wo search like a keyword search instead of a data >lookup? > >David ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Gary Krockover
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:Remote stockroom ? (1998)
[SearchString] usage (1997)
Credit card processing - UK (1997)
Associative lookup style? (1997)
I'm new (2001)
Protecting Images (2003)
[OT] Change permissions via FTP? (2002)
[WebDNA] MIDDLE problems (2012)
Modifying Carts (1999)
Pull Down Search (2000)
RE: Ongoing group search problems ... (1997)
FirstClass/WebCatalog (1999)
[SHOWIF] (1997)
WebCat2 - Getting to the browser's username/password data (1997)
[WebDNA] Failed to aquire lock on database error (2011)
There is a bug in 3.0.1 mac plug-in (1998)
Thanks Grant (1997)
PIXO support (1997)
WCS Newbie question (1997)
Multiple Pulldowns (1997)