[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