[Zope] Having problems with SQL methods

Peter Whysall pwhysall@technology.serco.com
Fri, 17 Sep 1999 15:53:30 +0100 (GMT Daylight Time)


I have an SQL method:

ID: insert_call_data.sql
TITLE: Insert Call Data Query
ARGUMENTS: user_id, call_type_id, call_desc, call_date, costcode_id

Query Template:

INSERT INTO calls 
(user_id,
 call_type_id,
 call_desc,
 call_date,
 costcode_id)
VALUES
(
<dtml-sqlvar user_id type=int>,
<dtml-sqlvar call_type_id type=int>,
<dtml-sqlvar call_desc type=string>,
<dtml-sqlvar call_date type=nb>,
<dtml-sqlvar costcode_id type=int>
);

When I do a change and test, I get the form to fill out, and I fill out
the arguments.

When I submit the query, I get this: 

Error, Missing Input: Missing input variable, user_id 

SQL used: 

Could not render the query template!

And this traceback:

Traceback (innermost last):
  File /opt/Zope/lib/python/ZPublisher/Publish.py, line 214, in
publish_module
  File /opt/Zope/lib/python/ZPublisher/Publish.py, line 179, in publish
  File /opt/Zope/lib/python/Zope/__init__.py, line 201, in
zpublisher_exception_hook
    (Object: insert_call_data.sql)
  File /opt/Zope/lib/python/ZPublisher/Publish.py, line 165, in publish
  File /opt/Zope/lib/python/ZPublisher/mapply.py, line 160, in mapply
    (Object: manage_test)
  File /opt/Zope/lib/python/ZPublisher/Publish.py, line 102, in
call_object
    (Object: manage_test)
  File /opt/Zope/lib/python/Shared/DC/ZRDB/DA.py, line 316, in manage_test
    (Object: insert_call_data.sql)
  File /opt/Zope/lib/python/Shared/DC/ZRDB/DA.py, line 295, in manage_test
    (Object: insert_call_data.sql)
  File /opt/Zope/lib/python/Shared/DC/ZRDB/DA.py, line 395, in __call__
    (Object: insert_call_data.sql)
  File /opt/Zope/lib/python/DocumentTemplate/DT_String.py, line 502, in
__call__
    (Object: <string>)
  File /opt/Zope/lib/python/Shared/DC/ZRDB/sqlvar.py, line 168, in render
    (Object: user_id)
Missing Input: (see above)

What am I doing wrong? 
Is this the best way of inserting data into tables?
Is there a document I should read before posting such newbie questions? (I
*have* read the Z SQL Methods User's Guide, but that seems to have nothing
on inserting data)

Regards

Peter.
--
Peter Whysall
Systems Engineer
Serco Technology