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:

    
  1. Re: Negative Range Error (Kalin Mintchev 2003)
  2. Re: Negative Range Error (Brian Boegershausen 2003)
  3. Re: Negative Range Error (Stuart Tremain 2003)
  4. Re: Negative Range Error (Matthew A Perosi 2003)
  5. Re: Negative Range Error (Brian Fries 2003)
  6. Re: Negative Range Error (Brian Boegershausen 2003)
  7. Re: Negative Range Error (Tim Robinson 2003)
  8. Negative Range Error (Brian Boegershausen 2003)
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:

Any 4.5 to 5.0 upgrade gotchas? (2003) Questions To Answer (1997) Running _every_ page through WebCat ? (1997) Checking Out! (1999) Just Testing (1997) More Applescript (1997) Problem with Showif & Applescript (1997) Problem displaying search result (1997) Extra carriage returns (1999) Restricting templates from causing havoc (2000) Sort Issue? (2000) Running 2 two WebCatalog.acgi's (1996) WebMerchant 3.0? (1998) calculating tax rates, mail order solutions and version 2 (1997) Checkboxes (1997) Authenticate (1997) multiple product databases (1997) Re:WebCat hosting sites? (1998) Deleting Orders (1997) PCS Emailer's role ? (1997)