Re: Negative Range Error
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 48803
interpreted = N
texte = Well I have added in the wbrk=and it is still not working. It works fine with positive coordinants, butonce a negative is introduced, it is a problem.I have tried switching the two numbers in the range also and it is stillgiving me an error.I am running WebDNA 4.0.2Is this a bug?Can someone tell me if this works in 4.5 becuase I will upgrade immediatelyif it is.SMSI.... your thoughts on this.Brian----- Original Message -----From: Tim Robinson
To: WebDNA Talk Sent: Wednesday, March 19, 2003 5:25 PMSubject: Re: Negative Range Error> 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 awbrk> delimiter. Because you have a '-' and a '.' it might help to specify awbrk> 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 rangefunction> > that has negative numbers?> >> > I am having many problems getting my search working for finding theradius> > 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 thelongitude> > around.> > I had a thought of just getting rid of the - signs in there, but some ofmy> > 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/>-------------------------------------------------------------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 I have added in the wbrk=and it is still not working. It works fine with positive coordinants, butonce a negative is introduced, it is a problem.I have tried switching the two numbers in the range also and it is stillgiving me an error.I am running WebDNA 4.0.2Is this a bug?Can someone tell me if this works in 4.5 becuase I will upgrade immediatelyif it is.SMSI.... your thoughts on this.Brian----- Original Message -----From: Tim Robinson To: WebDNA Talk Sent: Wednesday, March 19, 2003 5:25 PMSubject: Re: Negative Range Error> 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 awbrk> delimiter. Because you have a '-' and a '.' it might help to specify awbrk> 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 rangefunction> > that has negative numbers?> >> > I am having many problems getting my search working for finding theradius> > 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 thelongitude> > around.> > I had a thought of just getting rid of the - signs in there, but some ofmy> > 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/>-------------------------------------------------------------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/
Brian Boegershausen
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:
Date Calulation (1997)
Dreamweaver (2002)
BBEdit WedDNA Codeless Language Module (2004)
TaxTotal Problem (1997)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
[append] vs. [appendfile] delta + question? (1997)
JavaScript Image Problem (1998)
Big Databases (1997)
Date Calulation (1997)
OT: Help Wanted (2007)
Multiple catalog databases and showcart (1997)
Questions! (2000)
WebCatalog Technical Reference (1997)
PSC recommends what date format yr 2000??? (1997)
Allow/Deny with Webcat? (1998)
WC Database Format (1997)
Busy WebCatalog (2000)
WebCat2 - [include] tags (1997)
Calculating multiple shipping... (1997)