[WebDNA] Range calculation w/negative values
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107670
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.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.dbzipcitystatelatlong00501HOLTSVILLENY40.81-73.04--Gil Poulsen, Mac Wirehead************************AltiM@c ConsultingP.O. Box 2125Neptune, NJ 07754Voice: 609-359-0103************************
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.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.dbzipcitystatelatlong00501HOLTSVILLENY40.81-73.04--Gil Poulsen, Mac Wirehead************************AltiM@c ConsultingP.O. Box 2125Neptune, NJ 07754Voice: 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:
autosensing lanague selection (1997)
[WebDNA] PayPal Integration (2017)
Mac/network guy needed in Seattle (2004)
Ads.db (1997)
[WebDNA] error installing 6.2 on ubuntu (2011)
email (1998)
More on IE5 (2000)
Max Record length (1997)
Changing to a windows mounted share from a Mac OS X machine (2002)
I have troubles to send message out (1998)
Items XX to XX shown (1997)
Web Catalog 2 demo (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
WebDNA for Dummies (2004)
Storefornts (1997)
WebCatalog v2.1.1 (1998)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
RE: Migrating to NT (1997)
price change help (1998)
X etc.... (1999)