[Zope-DB] dumb INSERT Question
Michael Schwartz
mike at ziacom.us
Sun May 1 20:29:53 EDT 2005
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
More information about the Zope-DB
mailing list