[Zope-DB] dumb INSERT Question

[Charlie Clark]

On 2005-05-02 at 02:29:53 [+0200], Michael Schwartz <mike at ziacom.us> wrote:
> 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!

UserID != userId

variables in Python are case sensitive.

Charlie
-- 
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::