Re: Negative Range Error

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 48821
interpreted = N
texte = BrianThis may be a bit off track but I had some negative number issues a while back and instead of having -1145.82 I made it an equation ie [Math]0-1145.82[/Math]This may not be your answer but may give you a pointer to something. On Friday, March 21, 2003, at 02: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/ > > RegardsStuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837------------------------------------------------------------- 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)
BrianThis may be a bit off track but I had some negative number issues a while back and instead of having -1145.82 I made it an equation ie [math]0-1145.82[/Math]This may not be your answer but may give you a pointer to something. On Friday, March 21, 2003, at 02: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/ > > RegardsStuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837------------------------------------------------------------- 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/ Stuart Tremain

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:

Secure server question (1997) WebCatalog NT beta 18 problem (1997) Running _every_ page through WebCat ? (1997) Emailer Set Up (1997) SEA files (1996) [LOOKUP] (1997) Max Record length restated as maybe bug (1997) can webcat determine an image's pixel dimensions? (2000) No comment (1997) multiple price line in formula.db (2004) Price problem (1997) Is this possible, WebCat2.0 and checkboxes (1997) [date format] w/in sendmail (1997) popups, netscape vs explorer (1997) Using Checkbox (2000) Renaming DB fields (2000) Search design (1997) transferring values (1998) Webcat 3.0.7 & Webmerchant (2002) trouble updating records in database (1998)