Re: Negative Range Error
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 48816
interpreted = N
texte = I'm no expert with searching, but I have seen some strange things regarding numbersand math in WebDNA. Of course I can't remember any specifics right now, but....Can you put the [math] tag to some use in the search like we use the [url] tag?Just a thought. I have no idea if it would work, unfortunately I don't have time totest it for you I've got a WebDNA deadline of April 11th and still have about ahundred thousand lines of HTML/WebDNA lines of code to write :-(Matt Perosinj-singles.comijo.comBrian Fries wrote:> I ran some tests using 4.5.0 on OSX and found that I cannot search for> negative numbers at all when I specify type=num.>> I created range.db:> id value> 1 one> 10 ten> 200 two hundred> -50 negative 50> -200 negative 200> 73 seventy-three> -17 negative 17>> and tried searching:> [search db=[tRoot]test/range.db&eqIDdatarq=-17&idType=num]> [founditems][id] - [value]
> [/founditems][/search]>> ... and got nothing.>> I tried it with [url] around the -17, and still got nothing.>> I tried it with the value 73 instead and got a valid result.>> I tried it with -17 and type=text and found the -17 record.>> I tried it with a range, both via the rn method and the mr / xr> method and it works fine with positive numbers, but not with negative> numbers.>> My conclusion: WebDNA does not search properly for negative numbers> when using type=num. And clearly, except for eq and ne tests,> searching with type=text is not helpful.>> - (the other) Brian>> -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com> -->> On Thursday, March 20, 2003, at 07:05 AM, Brian Boegershausen wrote:>> > Well I have added in the wbrk=> > and it is still not working. It works fine with positive coordinants,> > but> > once a negative is introduced, it is a problem.> > I have tried switching the two numbers in the range also and it is> > still> > giving me an error.> > I am running WebDNA 4.0.2> >> > Is this a bug?> > Can someone tell me if this works in 4.5 becuase I will upgrade> > immediately> > if it is.> >> > SMSI.... your thoughts on this.> >> >> > Brian> >> > ----- Original Message -----> > From: Tim Robinson
> > To: WebDNA Talk > > Sent: Wednesday, March 19, 2003 5:25 PM> > Subject: 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 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:
I'm no expert with searching, but I have seen some strange things regarding numbersand math in WebDNA. Of course I can't remember any specifics right now, but....Can you put the [math] tag to some use in the search like we use the [url] tag?Just a thought. I have no idea if it would work, unfortunately I don't have time totest it for you I've got a WebDNA deadline of April 11th and still have about ahundred thousand lines of HTML/WebDNA lines of code to write :-(Matt Perosinj-singles.comijo.comBrian Fries wrote:> I ran some tests using 4.5.0 on OSX and found that I cannot search for> negative numbers at all when I specify type=num.>> I created range.db:> id value> 1 one> 10 ten> 200 two hundred> -50 negative 50> -200 negative 200> 73 seventy-three> -17 negative 17>> and tried searching:> [search db=[tRoot]test/range.db&eqIDdatarq=-17&idType=num]> [founditems][id] - [value]
> [/founditems][/search]>> ... and got nothing.>> I tried it with [url] around the -17, and still got nothing.>> I tried it with the value 73 instead and got a valid result.>> I tried it with -17 and type=text and found the -17 record.>> I tried it with a range, both via the rn method and the mr / xr> method and it works fine with positive numbers, but not with negative> numbers.>> My conclusion: WebDNA does not search properly for negative numbers> when using type=num. And clearly, except for eq and ne tests,> searching with type=text is not helpful.>> - (the other) Brian>> -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com> -->> On Thursday, March 20, 2003, at 07:05 AM, Brian Boegershausen wrote:>> > Well I have added in the wbrk=> > and it is still not working. It works fine with positive coordinants,> > but> > once a negative is introduced, it is a problem.> > I have tried switching the two numbers in the range also and it is> > still> > giving me an error.> > I am running WebDNA 4.0.2> >> > Is this a bug?> > Can someone tell me if this works in 4.5 becuase I will upgrade> > immediately> > if it is.> >> > SMSI.... your thoughts on this.> >> >> > Brian> >> > ----- Original Message -----> > From: Tim Robinson > > To: WebDNA Talk > > Sent: Wednesday, March 19, 2003 5:25 PM> > Subject: 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 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/
Matthew A Perosi
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:
Nested Lookups (1998)
problems with 2 tags shakur (1997)
Internet Advancement (2003)
Multiple catalog databases and showcart (1997)
price formula (1999)
Error: Permision deny. (2005)
Lookup & Form Variables (2000)
Showif, Hideif reverse logic ? (1997)
Three Guesses? (2004)
RE: Other Databases, access, filemaker etc. (2000)
Question about replacing words (1998)
[WebDNA] Ubuntu 18.04 & Apache2 & WebDNA fcgi - File upload error (2019)
WebCatalog (1998)
RE: Formulas.db + Users.db (1997)
Auction (2000)
WebCat for mass emailings (1997)
shownext problems (1998)
Replacing a Word (1999)
Make sure I understand this??? (1997)
SiteGuard Use Question (1997)