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 valuemust precede the larger value. Bit vague that in terms of negatives. Iwould assume that the larger negative number would need to go first. Butapart from that theorising, I'm wondering if it would help to put in a wbrkdelimiter. Because you have a '-' and a '.' it might help to specify a wbrkthat is different to that.Unfortunately I have no idea whether a negative value is even allowed...Regards,Tim-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +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 valuemust precede the larger value. Bit vague that in terms of negatives. Iwould assume that the larger negative number would need to go first. Butapart from that theorising, I'm wondering if it would help to put in a wbrkdelimiter. Because you have a '-' and a '.' it might help to specify a wbrkthat is different to that.Unfortunately I have no idea whether a negative value is even allowed...Regards,Tim-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +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)