Re: [WebDNA] Range calculation w/negative values
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107678
interpreted = N
texte = Affirmative, I tried reordering the high and low values but it would not work either way. I know that the range search definitely does not work unless the lowest number comes first, so the way the search is set up it would make the range -100 to -70. Like I said, I switched that around just for the heck of it but it still wouldn't go. On Nov 8, 2011, at 7:28 PM, Francisco Hirsch wrote: > Should the base be ordered? If so, have you taken into account that, > say, -70 is greater than -100? > > Francisco Hirsch > -- > http://www.ayudamac.com.ar > http://www.elasesordevinos.com.ar > http://www.fiscaldemesa.com.ar > > > > On 08/11/2011, at 21:07, Gil Poulsen
wrote: > >> >> On Nov 8, 2011, at 6:46 PM, Francisco Hirsch wrote: >> >>> Well, the use of negative signs is merely a convention, so it's ok >>> to exchange negative for positive >> >> Yeah, that's true. I just feel like it's cheating in the sense that >> if this was a worldwide database, I wouldn't have the luxury of >> being able to convert all the values to positives since there must >> be cases wherein two places would have the same exact longitude >> were it expressed as an absolute value. >> >>> >>> Francisco Hirsch >>> -- >>> http://www.ayudamac.com.ar >>> http://www.elasesordevinos.com.ar >>> http://www.fiscaldemesa.com.ar >>> >>> >>> >>> On 08/11/2011, at 10:11, 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 >> ************************ >> >> --------------------------------------------------------- >> 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:
Affirmative, I tried reordering the high and low values but it would not work either way. I know that the range search definitely does not work unless the lowest number comes first, so the way the search is set up it would make the range -100 to -70. Like I said, I switched that around just for the heck of it but it still wouldn't go. On Nov 8, 2011, at 7:28 PM, Francisco Hirsch wrote: > Should the base be ordered? If so, have you taken into account that, > say, -70 is greater than -100? > > Francisco Hirsch > -- > http://www.ayudamac.com.ar > http://www.elasesordevinos.com.ar > http://www.fiscaldemesa.com.ar > > > > On 08/11/2011, at 21:07, Gil Poulsen wrote: > >> >> On Nov 8, 2011, at 6:46 PM, Francisco Hirsch wrote: >> >>> Well, the use of negative signs is merely a convention, so it's ok >>> to exchange negative for positive >> >> Yeah, that's true. I just feel like it's cheating in the sense that >> if this was a worldwide database, I wouldn't have the luxury of >> being able to convert all the values to positives since there must >> be cases wherein two places would have the same exact longitude >> were it expressed as an absolute value. >> >>> >>> Francisco Hirsch >>> -- >>> http://www.ayudamac.com.ar >>> http://www.elasesordevinos.com.ar >>> http://www.fiscaldemesa.com.ar >>> >>> >>> >>> On 08/11/2011, at 10:11, 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 >> ************************ >> >> --------------------------------------------------------- >> 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:
Email Format (Umlaut) (2004)
WCS Newbie question (1997)
[WebDNA] 6.2 Monitor (2012)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
returning the missing value (1997)
Not really WebCat (1997)
flushdatabases (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
[WebDNA] menu & navaigation choices (2015)
Wanted: Broader string manipulation functions (1997)
Problems getting parameters passed into email. (1997)
WebCatalog2 Feature Feedback (1996)
CommandSecurity? (1997)
Browser Check for WebDNA compatability (1999)
[WebDNA] WebDNA Not Sending Email (2009)
More on the email templates (1997)
Way [OT] - OS 10.2 Server (2002)
RE: [WebDNA] Intermittent Encryption Issue (2009)
Smith Micro - no competition (2000)
[WriteFile] problems (1997)