Errrrgh! I had this problem long ago and I don't remember how I solved it. Waaaaay back when I was still using Access. Hmmm. First, turn on ODBC debugging. For this, we need to examine the SQL.log file it creates. Look at that and we need to see if python can talk to Access over ODBC. Troy -----Original Message----- From: CURTIS David [mailto:David.Curtis@state.or.us] Sent: Thursday, July 19, 2001 4:00 PM To: troy.farrell@wcg.com Subject: RE: [Zope] ODBC, SQL,Zope, NT4 , Jshell Sensitivity: Personal
troy.farrell@wcg.com 07/19/01 12:54PM >>> 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 There was no data matching this Insert a Customer query. Thanks for the quick reply. Here is what I get displayed on the screen. There was no data matching this Insert a Customer query. ---------------------------------------------------------------------------- ---- SQL used: There was no data matching this Insert a Customer query. Insert into customers ( customer_id, name, planet, age ) VALUES ( 'QW32', 'John Smith', 'Earth', 15 ) But using single quotes in the TEST tab did allow for appending. So Maybe there is hope? :-) -----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 )