[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