Re: [WebDNA] Range calculation w/negative values
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107675
interpreted = N
texte = On Nov 8, 2011, at 5:28 PM, Stuart Tremain wrote: > Have you tried URL'ing the values ?? You mean [search db=zipcodes.db&rnLATdatarq=[lowLat],[hiLat]&rnLONGdatarq=[url] [lowLong][/url],[url][hiLong][/ url]&LATtype=num&LONGtype=num&asZIPsort=1] Will give that a shot once I replace the db with the original one that has the negative values. But it looks like [url]-[/url] just gives you -. It seems like the range search should just work since the math context has no problem understanding nagative numbers. Maybe this is a bug that was fixed in 6.x? > > > On 09/11/2011, at 12:11 AM, Gil Poulsen 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 >> >> >> -- >> Gil Poulsen, Mac Wirehead >> >> ************************ >> AltiM@c Consulting >> P.O. Box 2125 >> Neptune, NJ 07754 >> Voice: 609-359-0103 >> ************************ >> >> >> --------------------------------------------------------- >> 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 > > --------------------------------------------------------- > 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:
On Nov 8, 2011, at 5:28 PM, Stuart Tremain wrote: > Have you tried URL'ing the values ?? You mean [search db=zipcodes.db&rnLATdatarq=[lowLat],[hiLat]&rnLONGdatarq=[url] [lowLong][/url],[url][hiLong][/ url]&LATtype=num&LONGtype=num&asZIPsort=1] Will give that a shot once I replace the db with the original one that has the negative values. But it looks like [url]-[/url] just gives you -. It seems like the range search should just work since the math context has no problem understanding nagative numbers. Maybe this is a bug that was fixed in 6.x? > > > On 09/11/2011, at 12:11 AM, Gil Poulsen 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 >> >> >> -- >> Gil Poulsen, Mac Wirehead >> >> ************************ >> AltiM@c Consulting >> P.O. Box 2125 >> Neptune, NJ 07754 >> Voice: 609-359-0103 >> ************************ >> >> >> --------------------------------------------------------- >> 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 > > --------------------------------------------------------- > 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:
referrer and no caches (1997)
wish list (2002)
Date Time Oddness (1999)
Close-to Comparison Code (1998)
WebCatalog for guestbook ? (1997)
HELP WITH DATES (1997)
WebCat2 - Getting to the browser's username/password data (1997)
[WebDNA] Code works in v6 but not in v7 (2010)
Exclamation point (1997)
A dynamic database. (1997)
Searching,Brain Dead! (1999)
Navigator 4.0 & tables (1997)
[input] [/input] (1997)
Error, 101 a DNS problem ? (1997)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
duplicate cart numbers - New P3P Rule (2002)
%@#*& back button!!! (1999)
[SearchString] problem with [search] context (1997)
Some Advise needed (1997)
Showing unopened cart (1997)