[Zope] ODBC, SQL,Zope, NT4 , Jshell

[Farrell, Troy]

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 )