Re: Strange Update query ...

Hiroshi, I made several tests, and the log always shows an UPDATE statement
filled with constant values, such as:

'UPDATE mytable SET myfield1=4,myfield2=5,myfield3=6
WHERE (id=6 AND myfield1=1 AND myfield2=2 AND myfield3=3 )'

I tried with several data types, with and without explicit declaration of
the 'myvaluex' variables, and never saw variable names in the generated
UPDATE statement.

Thomas Chabaud's log shows:

'UPDATE mytable SET myfield1=myvalue1,myfield2=myvalue2,myfield3=myvalue3
WHERE (id=6 AND myfield1=myvalue1 AND myfield2=myvalue2 AND
myfield3=myvalue3 )'

I can't figure out how variable names could appear in the UPDATE statement,
so I think Thomas Chabaud should provide some information about the nature
of those variables.


Hélder M. Vieira