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 numbers and 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 to test it for you I've got a WebDNA deadline of April 11th and still have about a hundred thousand lines of HTML/WebDNA lines of code to write :-(Matt Perosi nj-singles.com ijo.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:

    
  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)
I'm no expert with searching, but I have seen some strange things regarding numbers and 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 to test it for you I've got a WebDNA deadline of April 11th and still have about a hundred thousand lines of HTML/WebDNA lines of code to write :-(Matt Perosi nj-singles.com ijo.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)