Re: Problem with UPDATE and User Variables

[Paul DuBois]

At 18:32 +0100 1/24/02, Peter Bremer wrote:
>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...

Works for me, if I substitute a real value for value1.  Your
first statement as shown above isn't actually legal.  How do
you establish what value1 is?

>
>Regards,
>	Peter Bremer