Hi Mylein,
Our log shows the following Information:
SQL:
UPDATE tbl_users SET lastupdated = ?, lastlogondate = ? WHERE id
= ? AND ( ( lastupdated = ? ) OR ( ? IS NULL AND lastupdated IS
NULL ))
sql_param:
<!%T|2007-10-23 11:37:04.589|!%>
<!%T|2007-10-23 11:37:04.588|!%>
<!%1|49|!%>
<!%T|2007-10-11 11:32:49.559|!%>
<!%T|2007-10-11 11:32:49.559|!%>
----------------------
I don't really get the '? IS NULL' part. I guess PostgreSQL is expecting
a column name there rather than a timestamp. Or maybe you need to cast
the parameter to make this work properly. Anyhow if this works directly
with PostgreSQL that should also work with Sequoia.
Are you sure that your query is correct or does what you intended to do?
Thanks for the feedback,
Emmanuel
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
