Re: [WebDNA] Range calculation w/negative values
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107673
interpreted = N
texte = Well, the use of negative signs is merely a convention, so it's ok to exchan=ge negative for positiveFrancisco Hirsch--=20http://www.ayudamac.com.arhttp://www.elasesordevinos.com.arhttp://www.fiscaldemesa.com.arOn 08/11/2011, at 10:11, Gil Poulsen
wrote:> Haven't posted to this list in ages, but every so often you run into somet=hing... Doing a range calculation as part of a distance search based on ZIP c=ode (aka Great Circle calculation). For whatever reason, I can't get the sea=rch to work on negative values, and the longitude of every city in the U.S. i=s 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[lo=wLong],[hiLong]&LATtype=3Dnum&LONGtype=3Dnum&asZIPsort=3D1]>=20> The [lowLong]and [hiLong] values are negative as well. If I remove the ent=ire longitude section the search works fine. And if I change the values in t=he db for longitude to positive, the search works, but that just seems wrong=...>=20> zipcodes.db> zip city state lat long> 00501 HOLTSVILLE NY 40.81 -73.04>=20>=20> --> Gil Poulsen, Mac Wirehead>=20> ************************> AltiM@c Consulting> P.O. Box 2125> Neptune, NJ 07754> Voice: 609-359-0103> ************************>=20>=20> ---------------------------------------------------------> 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
Associated Messages, from the most recent to the oldest:
Well, the use of negative signs is merely a convention, so it's ok to exchan=ge negative for positiveFrancisco Hirsch--=20http://www.ayudamac.com.arhttp://www.elasesordevinos.com.arhttp://www.fiscaldemesa.com.arOn 08/11/2011, at 10:11, Gil Poulsen wrote:> Haven't posted to this list in ages, but every so often you run into somet=hing... Doing a range calculation as part of a distance search based on ZIP c=ode (aka Great Circle calculation). For whatever reason, I can't get the sea=rch to work on negative values, and the longitude of every city in the U.S. i=s 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[lo=wLong],[hiLong]&LATtype=3Dnum&LONGtype=3Dnum&asZIPsort=3D1]>=20> The [lowLong]and [hiLong] values are negative as well. If I remove the ent=ire longitude section the search works fine. And if I change the values in t=he db for longitude to positive, the search works, but that just seems wrong=...>=20> zipcodes.db> zip city state lat long> 00501 HOLTSVILLE NY 40.81 -73.04>=20>=20> --> Gil Poulsen, Mac Wirehead>=20> ************************> AltiM@c Consulting> P.O. Box 2125> Neptune, NJ 07754> Voice: 609-359-0103> ************************>=20>=20> ---------------------------------------------------------> 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
Francisco Hirsch
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:
WebCatalog NT (1996)
access denied problem (1997)
TCPconnect issue (2000)
problems with 2 tags shakur (1997)
Forwarding Orders Via Email (1998)
Template Security error (1997)
Secure Web Server (1999)
Append File help needed (2000)
Using Japanesse text with webcat. (1998)
More on the email templates (1997)
Extended [ConvertChars] (1997)
Emailer update for Mac? (1998)
foreign languages, email, webcat (1998)
Why WebDNA is not popular (2002)
encryption madness (2003)
Me know logical no need (2002)
Combining search criteria (2000)
Help with nested search (1998)
how to add to triggers.db (1998)
Running _every_ page through WebCat ? (1997)