Well the first thing I notice is that you have 'description' in there twice. I don't know if that's the problem you're encountering now, but it could be a bad thing. Harry

Hi all,

Part of a site I'm working on needs to be able to insert job numbers into a database. I'm using PostgreSQL as the backend and psycopg as the connecter. I am able to select values from the database without problems. However, I can insert anything.

I have a dtml document that prompts for values called addJobNumber. This has an action of another dtml document named commitJob. commitJob has a dtml-call to insert_job which is a Z SQL method.

The Z SQL method is as follows:

insert into y8 values( now(), now(), <dtml-sqlvar client type="string"> <dtml-sqlvar description type="string">, <dtml-sqlvar product type="string">, nextval('y8_number'), <dtml-sqlvar description type="string">, <dtml-sqlvar client_job_number type="string">, <dtml-sqlvar client_po_number type="string">, <dtml-sqlvar client_contact type="string">, <dtml-sqlvar tech_contact type="string">, <dtml-sqlvar job_close_date type="string"> )

When I try this, I get an error saying :

Missing input variable, client

Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 114, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 158, in zpublisher_exception_hook (Object: localhost) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 98, in publish File /usr/local/zope/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: commitJob) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: commitJob) File /usr/local/zope/lib/python/OFS/DTMLDocument.py, line 127, in __call__ (Object: commitJob) File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 473, in __call__ (Object: commitJob) File /usr/local/zope/lib/python/Shared/DC/ZRDB/DA.py, line 414, in __call__ (Object: insert_job) File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 473, in __call__ (Object: <string>) File /usr/local/zope/lib/python/Shared/DC/ZRDB/sqlvar.py, line 99, in render (Object: client) Missing Input: (see above)

If I remove the dtml-call in the commitJob document and just print each value using <dtml-var client><br><br> All values print as expected (as entered on the previous form)

Is there anything obvious that I'm missing here that could be causing this problem ?

TIA,