List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 5 2000 6:52pm
Subject:Re: Another beginner question ...
View as plain text  
At 7:37 PM +0100 2000-02-05, xcm wrote:
>Hi,
>
>I have a new question (excuse me but it's my first step whith MySql...).
>
>I Have a strange problem :
>
>I've a table named "admin"
>
>Several fields in "admin" : "nom","prenom","id_cookie","time_cookie",...
>
>There's no problem when i use this request : select nom,prenom from
>admin where id_cookie<5000;
>
>But when i try : select nom,prenom from admin where id_cookie+500<5000;
>
>the server return "ERROR: parse error near '+100<5000' at line 1
>
>It seem that the arithmetic operation whas the problem ... (i also try
>whith (id_cookie+500<500)<5000 but i've the same result !!!)
>
>I also make the test whith : (100+100)<500 (just to see) but that
>doesn't work !!!
>
>Thanks a lot in advance for your answer (and excuse me for my very very
>very bad english :-)))


Possibly the e+500 is being interpreted as the exponent of a number
in scientific notation.  The statement looks legal to me, though.
Try perhaps (id_cookie) + 500 < 5000.

-- 
Paul DuBois, paul@stripped
Thread
Another beginner question ...xcm5 Feb
  • RE: Another beginner question ...Roy Nasser5 Feb
  • Re: Another beginner question ...Paul DuBois5 Feb
  • SV: Another beginner question ...Per Claesson5 Feb