Neil, Did you define "Surname" in the Arguments section of your zSql form? David neil_b@yahoo.co.uk wrote:
I am close to getting a form to update a database, but I seem to have misunderstood how ZSQLMethod gets variables:
The Form:
<form action="update_table"> <input type="hidden" name="PeopleID" value="9999"> <input type="text" name="Surname" value=""> <INPUT type="submit" value="save" name="submit"> </form>
The action method:
<dtml-call sql_update_tblPeople>
Finally the ZSQLMethod (no arguments set):
UPDATE tblPeople SET tblPeople.Surname = <dtml-sqlvar Surname type="string"> WHERE tblPeople.PeopleID = <dtml-sqlvar PeopleID type="int">
From all the documentation and How-tos I have read so far, this should work, but I get:
missing input variable Surname
Changing the update_table method to:
<dtml-var Surname>
shows that the form delivers the right value.
Can anyone help me to spot my silly error?
TIA
Neil
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )