Re: [WebDNA] Range calculation w/negative values
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107674
interpreted = N
texte = Did try ge and le for the low and high, no dice. On Nov 8, 2011, at 5:32 PM, Govinda wrote: >> Haven't posted to this list in ages, but every so often you run >> into something... Doing a range calculation as part of a distance >> search based on ZIP code (aka Great Circle calculation). For >> whatever reason, I can't get the search to work on negative values, >> and the longitude of every city in the U.S. is expressed as a >> negative value. Using WebCat 5.1e on an old Mac mini G4. >> >> This is the basic search, actually comes from something another >> individual on the list posted years ago: >> >> [search db=zipcodes.db&rnLATdatarq=[lowLat], >> [hiLat]&rnLONGdatarq=[lowLong], >> [hiLong]&LATtype=num&LONGtype=num&asZIPsort=1] >> >> The [lowLong]and [hiLong] values are negative as well. If I remove >> the entire longitude section the search works fine. And if I change >> the values in the db for longitude to positive, the search works, >> but that just seems wrong... >> >> zipcodes.db >> zip city state lat long >> 00501 HOLTSVILLE NY 40.81 -73.04 > > Hi Gil > > Have you tried using the 'ge' and 'le' (or 'gr' and 'ls') comparison > operators (if I said that right)? ... instead of the 'rn' operator. > > -G--------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list
. > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us > -- Gil Poulsen, Mac Wirehead ************************ AltiM@c Consulting P.O. Box 2125 Neptune, NJ 07754 Voice: 609-359-0103 ************************
Associated Messages, from the most recent to the oldest:
Did try ge and le for the low and high, no dice. On Nov 8, 2011, at 5:32 PM, Govinda wrote: >> Haven't posted to this list in ages, but every so often you run >> into something... Doing a range calculation as part of a distance >> search based on ZIP code (aka Great Circle calculation). For >> whatever reason, I can't get the search to work on negative values, >> and the longitude of every city in the U.S. is expressed as a >> negative value. Using WebCat 5.1e on an old Mac mini G4. >> >> This is the basic search, actually comes from something another >> individual on the list posted years ago: >> >> [search db=zipcodes.db&rnLATdatarq=[lowLat], >> [hiLat]&rnLONGdatarq=[lowLong], >> [hiLong]&LATtype=num&LONGtype=num&asZIPsort=1] >> >> The [lowLong]and [hiLong] values are negative as well. If I remove >> the entire longitude section the search works fine. And if I change >> the values in the db for longitude to positive, the search works, >> but that just seems wrong... >> >> zipcodes.db >> zip city state lat long >> 00501 HOLTSVILLE NY 40.81 -73.04 > > Hi Gil > > Have you tried using the 'ge' and 'le' (or 'gr' and 'ls') comparison > operators (if I said that right)? ... instead of the 'rn' operator. > > -G--------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us > -- Gil Poulsen, Mac Wirehead ************************ AltiM@c Consulting P.O. Box 2125 Neptune, NJ 07754 Voice: 609-359-0103 ************************
Gil Poulsen
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:
Q on the best way to set up a security function so users canedit records (1999)
New 4.5 installer (2002)
WebCat/CyberStudio Compatibility (1998)
Problem when Inputing text (1999)
When do we get to request new features? (1999)
addlineitems (2003)
Version f1 status (1997)
What is WebDNA (1997)
[WebDNA] Permission Settings (2009)
international time (1997)
international time (1997)
Multiple prices (1997)
NT version (1997)
Strange search... (2001)
Error with [applescript] (1999)
WebCatalog Mac 2.1b3 (1997)
[OT] Checkboxes! Javascript? (2005)
Add a field to the error log? (1997)
[ShowNext] (1997)
RequiredFields template (1997)