Re: [WebDNA] Range calculation w/negative values
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107672
interpreted = N
texte = > 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.>=20> This is the basic search, actually comes from something another =individual on the list posted years ago:>=20> [search =db=3Dzipcodes.db&rnLATdatarq=3D[lowLat],[hiLat]&rnLONGdatarq=3D[lowLong],[=hiLong]&LATtype=3Dnum&LONGtype=3Dnum&asZIPsort=3D1]>=20> 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...>=20> zipcodes.db> zipcitystatelatlong> 00501HOLTSVILLENY40.81-73.04Hi GilHave you tried using the 'ge' and 'le' (or 'gr' and 'ls') comparison =operators (if I said that right)? ... instead of the 'rn' operator.-G=
Associated Messages, from the most recent to the oldest:
> 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.>=20> This is the basic search, actually comes from something another =individual on the list posted years ago:>=20> [search =db=3Dzipcodes.db&rnLATdatarq=3D[lowLat],[hiLat]&rnLONGdatarq=3D[lowLong],[=hiLong]&LATtype=3Dnum&LONGtype=3Dnum&asZIPsort=3D1]>=20> 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...>=20> zipcodes.db> zipcitystatelatlong> 00501HOLTSVILLENY40.81-73.04Hi GilHave you tried using the 'ge' and 'le' (or 'gr' and 'ls') comparison =operators (if I said that right)? ... instead of the 'rn' operator.-G=
Govinda
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:
Runnaway Trigger (2007)
RE: Emailer prefs in two places ... (1997)
can WC render sites out? (1997)
Feature Request (2003)
quitting (1997)
Just Testing (1997)
do you have a webcatalog tool you want to sell? (1999)
unbreakable space on windows (2008)
format problem on NT? (1997)
Help! WebCat2 bug (1997)
How To question on setting up downloads (1997)
Frames and WebCat (1997)
Can this be done? (1997)
Can ShowNext do this? (2000)
WebCat2b15MacPlugin - [protect] (1997)
[WebDNA] Hosting WebDNA on a shared hosting account (2016)
RE: problem with applets embedded in tpl files (1997)
creating writefile data from a nested search (1997)
test mail (2004)
Stay on Products page (2003)