Re: Negative Range Error
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 48823
interpreted = N
texte = just a thought (haven't tested it): ...... &eqIDdatarq=-17&idType=num...and maybe [url] the things...On Thu, 20 Mar 2003, Brian Boegershausen wrote:> I just finished running some tests on WebDNA 4.5.1 Raq3i Platform, and I am > getting the same error from this Bug. > This is the second bug I have found in the last couple months.... do I win a > prize?? > Not to 100% say this is a bug. No one has written me back from SMSI to > substantiate it, plus it could just be a limitation of the software which is > not properly documented. > But it just seems that if they took the time to state that you had to put > the smaller value first in the range search string, that you should write > this down too. > > Brian B > > ----- Original Message ----- > From: Brian Fries
> To: WebDNA Talk > Sent: Thursday, March 20, 2003 12:01 PM > Subject: Re: Negative Range Error > > > > 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/ > ------------------------------------------------------------- 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:
just a thought (haven't tested it): ...... &eqIDdatarq=-17&idType=num...and maybe [url] the things...On Thu, 20 Mar 2003, Brian Boegershausen wrote:> I just finished running some tests on WebDNA 4.5.1 Raq3i Platform, and I am > getting the same error from this Bug. > This is the second bug I have found in the last couple months.... do I win a > prize?? > Not to 100% say this is a bug. No one has written me back from SMSI to > substantiate it, plus it could just be a limitation of the software which is > not properly documented. > But it just seems that if they took the time to state that you had to put > the smaller value first in the range search string, that you should write > this down too. > > Brian B > > ----- Original Message ----- > From: Brian Fries > To: WebDNA Talk > Sent: Thursday, March 20, 2003 12:01 PM > Subject: Re: Negative Range Error > > > > 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/ > ------------------------------------------------------------- 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/
Kalin Mintchev
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:
WebCat b15 Mac plug-in (1997)
WebMerchant 1.6 and SHTML (1997)
Rhapsody? (1997)
attn: smitmicro - cart limitation (2002)
Moment of Thanks (1997)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
how to determine the actual file format of an image file? (2002)
Date search - yes or no (1997)
[include ...] behavior (1997)
Help! WebCat2 bug (Ben's input) (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Realtor Search (2000)
Forcing a NEWCART (1997)
WCS Newbie question (1997)
one item in several different categories? (2000)
Authenticate (1997)
Sendmail and textarea (1998)
Date Sorting (1997)
Any WebCatalog Server providers in Seattle? (1998)
More on the email templates (1997)