Re: Negative Range Error
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 48791
interpreted = N
texte = Well, according to the docs: When specifying a range, the smaller value must precede the larger value. Bit vague that in terms of negatives. I would assume that the larger negative number would need to go first. But apart from that theorising, I'm wondering if it would help to put in a wbrk delimiter. Because you have a '-' and a '.' it might help to specify a wbrk that is different to that.Unfortunately I have no idea whether a negative value is even allowed...Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: Brian Boegershausen
> Reply-To: (WebDNA Talk) > Date: Wed, 19 Mar 2003 16:31:39 > To: (WebDNA Talk) > Subject: Negative Range Error > > Has anyone successfully written code to do a search using the range function > that has negative numbers? > > I am having many problems getting my search working for finding the radius > around a zip code by latitude and longitude. > It works find for long/lats that are not negative numbers, but once I > introduct a - in there, I do not get any results. > > Here is my search: > > db=coordinants.db&rnLATITUDEdatarq=47.391072 > 47.680736&rnLONGITUDEdatarq=-52.998186 -53.427236&LATITUDEtype=num&LONGITUDE > type=num&asSTATEsort=1&asZIPCODEsort=2&ZIPCODEsumm=T > > > I get the same bad results if I switch the 2 coordinants in the longitude > around. > I had a thought of just getting rid of the - signs in there, but some of my > coordinants are around the pos neg border and it will not produce the > correct results. > > Brian > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Well, according to the docs: When specifying a range, the smaller value must precede the larger value. Bit vague that in terms of negatives. I would assume that the larger negative number would need to go first. But apart from that theorising, I'm wondering if it would help to put in a wbrk delimiter. Because you have a '-' and a '.' it might help to specify a wbrk that is different to that.Unfortunately I have no idea whether a negative value is even allowed...Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: Brian Boegershausen > Reply-To: (WebDNA Talk) > Date: Wed, 19 Mar 2003 16:31:39 > To: (WebDNA Talk) > Subject: Negative Range Error > > Has anyone successfully written code to do a search using the range function > that has negative numbers? > > I am having many problems getting my search working for finding the radius > around a zip code by latitude and longitude. > It works find for long/lats that are not negative numbers, but once I > introduct a - in there, I do not get any results. > > Here is my search: > > db=coordinants.db&rnLATITUDEdatarq=47.391072 > 47.680736&rnLONGITUDEdatarq=-52.998186 -53.427236&LATITUDEtype=num&LONGITUDE > type=num&asSTATEsort=1&asZIPCODEsort=2&ZIPCODEsumm=T > > > I get the same bad results if I switch the 2 coordinants in the longitude > around. > I had a thought of just getting rid of the - signs in there, but some of my > coordinants are around the pos neg border and it will not produce the > correct results. > > Brian > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Tim Robinson
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 Work (2001)
Configuring E-mail (1997)
[WebDNA] Multiple e-mail sending (2011)
Never ending problem.... (2000)
What file? (1997)
RE: [WebDNA] Installing WebDNA on VPS (2008)
Webcat2, WebCommerce, Mod 10 etc. (1997)
[WebDNA] Brian Harrington (2019)
2.0.1 new commands and contexts (1997)
HomePage Caution (1997)
[protect] on NT? (1997)
database paths/names, and a typo (1997)
[ShowIf] and empty fields (1997)
search / summary (2005)
Server Load Tester (2000)
Help formatting search results w/ table (1997)
Encrypt and Commit Me (1998)
Trigger alternatives please ... (2004)
Bug? (1997)
Passing info in [Addlineitem] (1997)