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:
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
template not found error (1998)
DNS Lookup 2 (2000)
Add more fields to an existent data base (1997)
RAM problems, [appendfile] problems (1998)
Showing unopened cart (1997)
PCS Frames (1997)
RE: [WebDNA] Sorting -- Dealing with Blanks (2008)
Adding time above 24 hours (2002)
Using Plug-In while running 1.6.1 (1997)
WebDNA Upgrade Problems (2003)
PIXO support (1997)
Credit Card Number checking (1997)
Email Problems (2000)
[append] vs. [appendfile] delta + question? (1997)
Reversed words (1997)
protect tag on NT IIS (1997)
What file? (1997)
ImageMap (1997)
transferring values (1998)