Re: Range Comparisons
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 33120
interpreted = N
texte = You cannot do two comparisons on the same field in one search. Either do two searches or I believe you can use a group field (containing just the one field). It is just one of those things...John PeacockRobert Wade wrote: > > Thank you for replying, Aaron. > > I think you might have missed the original question... I need to do this search a > little backwards. The low and high end of the range are actually fields in the > database, not user input. They will be submitting one number, which I'm trying to get > to match or fall between the low and high in the db. > > Exampe db... > > ZipStart ZipEnd > 47600 47799 > 47800 47999 > 48000 49999 > > These database entries will change weekly. > > Then the search would use one zip code number, [zipcode], that the user posted from a > form on the previous page. The search is supposed to find a match or or fall between > ZipStart and ZipEnd. That's where I came up with the following which seems like it > should work, but doesn't... > > [search > db=firms.db&geZipStartdatarq=[zipcode]&leZipEnddatarq=[zipcode]&max=1&ZipStarttype=num&ZipEndtype=num] > > The way the rn search comparison seems to work, is the opposite of this. Using a range > of numbers in the search to match one field in the database. > > Thanks for your help. > > -RW > > Aaron Lynch wrote: > > > Your exact premise is in the docs: > > rnzipcodedata=92069 93090&zipcodetype=num > > > > or you could use clzipcodedata=92069&clzipcodedata=10 to find all records > > within '10' > > > > or, you can use mr for min and xr for the max values. > > > > (don't feel bad, I missed this recently as well, the M is too hard ri F'ing > > R or I'd just be condescending and say... well, you know RT*M :) > > > > > > ------------------------------------------------------------- > 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://search.smithmicro.com/------------------------------------------------------------- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
You cannot do two comparisons on the same field in one search. Either do two searches or I believe you can use a group field (containing just the one field). It is just one of those things...John PeacockRobert Wade wrote: > > Thank you for replying, Aaron. > > I think you might have missed the original question... I need to do this search a > little backwards. The low and high end of the range are actually fields in the > database, not user input. They will be submitting one number, which I'm trying to get > to match or fall between the low and high in the db. > > Exampe db... > > ZipStart ZipEnd > 47600 47799 > 47800 47999 > 48000 49999 > > These database entries will change weekly. > > Then the search would use one zip code number, [zipcode], that the user posted from a > form on the previous page. The search is supposed to find a match or or fall between > ZipStart and ZipEnd. That's where I came up with the following which seems like it > should work, but doesn't... > > [search > db=firms.db&geZipStartdatarq=[zipcode]&leZipEnddatarq=[zipcode]&max=1&ZipStarttype=num&ZipEndtype=num] > > The way the rn search comparison seems to work, is the opposite of this. Using a range > of numbers in the search to match one field in the database. > > Thanks for your help. > > -RW > > Aaron Lynch wrote: > > > Your exact premise is in the docs: > > rnzipcodedata=92069 93090&zipcodetype=num > > > > or you could use clzipcodedata=92069&clzipcodedata=10 to find all records > > within '10' > > > > or, you can use mr for min and xr for the max values. > > > > (don't feel bad, I missed this recently as well, the M is too hard ri F'ing > > R or I'd just be condescending and say... well, you know RT*M :) > > > > > > ------------------------------------------------------------- > 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://search.smithmicro.com/------------------------------------------------------------- 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://search.smithmicro.com/
John Peacock
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:2nd WebCatalog2 Feature Request (1996)
[LOOKUP] (1997)
Off-topic: valid email address characters? (2002)
F2 to F3 rocky transition (1997)
Download URL & access on the fly ? (1997)
WebCat2 beta 11 - new prefs ... (1997)
Sending mail (was forms and variables) (1998)
FW: Shipping calculations (1997)
Understanding texta (1997)
Emailer (WebCat2) (1997)
More on the email templates (1997)
Interesting speed comparison .. (2003)
Multiple Pulldowns (1997)
Supressing Error Messages (1998)
RE: Forcing Paragraph Breaks on Results - Yes you can replace String for String! (1998)
emailer (1997)
AOL refuses some e-mails (2000)
Max Record length (1997)
WebCatalog as a ListServ (1998)
Revisit: speed test (2002)