[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.db zipcitystatelatlong 00501HOLTSVILLENY40.81-73.04 -- 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:

    
  1. Re: [WebDNA] Range calculation w/negative values (Gil Poulsen 2011)
  2. Re: [WebDNA] Range calculation w/negative values (Francisco Hirsch 2011)
  3. Re: [WebDNA] Range calculation w/negative values (Gil Poulsen 2011)
  4. Re: [WebDNA] Range calculation w/negative values (Gil Poulsen 2011)
  5. Re: [WebDNA] Range calculation w/negative values (Gil Poulsen 2011)
  6. Re: [WebDNA] Range calculation w/negative values (Francisco Hirsch 2011)
  7. Re: [WebDNA] Range calculation w/negative values (Govinda 2011)
  8. Re: [WebDNA] Range calculation w/negative values (Stuart Tremain 2011)
  9. [WebDNA] Range calculation w/negative values (Gil Poulsen 2011)
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 zipcitystatelatlong 00501HOLTSVILLENY40.81-73.04 -- 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:

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)