At 7:37 PM +0100 2000-02-05, xcm wrote:
>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