On 2005-05-02 at 02:29:53 [+0200], Michael Schwartz <[EMAIL PROTECTED]> 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 ! :::: _______________________________________________ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db