RE: Problem with UPDATE and User Variables

2002-01-24 Thread Peter Bremer
Ooops!! This seems to be a bug in EMS MySQL Manager... Sorry to bother you all... Regards Peter -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: do 24 jan 2002 18:51 To: Peter Bremer; Mysql (E-mail) Subject: Re: Problem with UPDATE and User Variables At

Problem with UPDATE and User Variables

2002-01-24 Thread Peter Bremer
Hi, Can anybody explain why the following does not work? SELECT @variable := value1; UPDATE table SET field1 = @variable WHERE field2 = value2; The result is always that field1 is set to NULL... Regards, Peter Bremer

Help! Problems with ASP

2002-01-24 Thread Peter Bremer
--> False set rst = con.Execute ("SELECT 1+1 AS Result") Response.Write (rst.EOF & "") ' --> True ?!?!?!?! %> Please help! I'm new to MySQL, and I'm beginnin