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:

WebCatalog and Macromedia Flash (1998) Using Applescript to process WebCatalog functions (1998) multiple record replace (2001) WebCatalog and WebMerchant reviewed by InfoWorld (1997) [WebDNA] favorite db server with webDNA (2011) Upgrading old WebCat Database Files (1997) Error Lob.db records error message not name (1997) WebCommerce: Folder organization ? (1997) WebDNA Server not running (2006) Totally ignored by Smithmicro (2004) More on [purchase] (1998) Three new problems ... (1997) OT (maybe) Setting up local (non internet) test computers (2000) Caching problem... (2000) Upgrading old WebCat Database Files (1997) WCS Newbie question (1997) calender with business days (1998) Multi Colonns (1998) Corruption in images (2004) OLD ORDERS (1998)