I have a Z SQL method that looks like this:
Arguments: userId, roleId
INSERT INTO UserRoles
(Id_User,
Id_Role)
VALUES
(<dtml-sqlvar userId type="int">,
<dtml-sqlvar roleId type="int">)
I test the method:
UserId 14
RoleId 12
I get back:
Error, exceptions.ValueError: Missing input variable, userId
-------------------------------------------------------------
SQL used: Could not render the query template!
This is a form generated by Zope... how could it be missing the userId
field?
What am I doing wrong? Does it have something to do with the "int"
data type? I am comparing it vs. a working INSERT, and everything
looks the same.
TIA!!! I'm going crazy looking at for errors!
- Mike
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db
