Billy Saelim
2011-05-09 15:26:38 UTC
Hi,
http://plone.org/products/ploneformgen/documentation/tutorial/sql-crud/tutorial-all-pages
When I followed the steps of this tutorial, I could not get update to work
unless I put quotes int in the WHERE clause as below:
Not working
-----------------
UPDATE conference_registration
SET
<dtml-sqltest string1 type=string>,
<dtml-sqltest string2 type=string>
WHERE <dtml-sqltest uid type=int>
Working
------------
UPDATE conference_registration
SET
<dtml-sqltest string1 type=string>,
<dtml-sqltest string2 type=string>
WHERE <dtml-sqltest uid type="int">
Thanks.
Billy
http://plone.org/products/ploneformgen/documentation/tutorial/sql-crud/tutorial-all-pages
When I followed the steps of this tutorial, I could not get update to work
unless I put quotes int in the WHERE clause as below:
Not working
-----------------
UPDATE conference_registration
SET
<dtml-sqltest string1 type=string>,
<dtml-sqltest string2 type=string>
WHERE <dtml-sqltest uid type=int>
Working
------------
UPDATE conference_registration
SET
<dtml-sqltest string1 type=string>,
<dtml-sqltest string2 type=string>
WHERE <dtml-sqltest uid type="int">
Thanks.
Billy