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

[Farrell, Troy]

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 )