what happens if you change to <dtml-sqlvar name="customer_id" type="nb">, <dtml-sqlvar name="name" type="nb">, <dtml-sqlvar name="planet" type="nb" optional>, <dtml-sqlvar name="age" type="int" optional> What is the error message? Is the traceback in the HTML source? Troy -----Original Message----- From: CURTIS David [mailto:David.Curtis@state.or.us] Sent: Thursday, July 19, 2001 1:43 PM To: Zope@zope.ORG Subject: [Zope] ODBC, SQL,Zope, NT4 , Jshell Sensitivity: Personal Hi, I am trying to append records into an access database from Zope ZSQL. I am using the tutorial Created by jshell that was Last modified on 2000/10/13. I have his setup and it appears to be working except for the problem that no records actually get put into database. I get no errors to help me either. I have tried to using the SQL syntax Insert into customers ( customer_id, name, planet, age ) VALUES ( <dtml-sqlvar customer_id type=nb>, <dtml-sqlvar name type=nb>, <dtml-sqlvar planet type=nb optional>, <dtml-sqlvar age type=int optional> ) If I "TEST" The database connection with a select statement I get records output. YEA If I TEST the datbase connection with a delete statement - records deleted. YEA BUT If I TEST the database connection with a insert statement I get an error. No Traceback. BAD Insert into customers (customer_id, name, planet, age) VALUES ("test", "test2", "test3", 77) Note this syntax is working in MS Access. The database connection is open. Current Setup Running NT 4 with Zope versions (Zope 2.3.2 (binary release, python 1.5.2, win32-x86) Python Version 1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)] System Platform win32 ODBC - Microsft Access Driver(*.mdb) version 4.00.5301.01 Any ideas on what to do? _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )