[Zope] multiple SQL commands over ODBC

[Donald Braman]

With the semicolon, I get: 

Error, sql.error: ('37000', -3517,'[Microsoft][ODBC Microsoft Access 
Driver] Characters found after end of SQL statement.'

Without the semicolon I get: 

Error, sql.error: ('37000', -3100,"[Microsoft][ODBC Microsoft Access 
Driver] Syntax error. in query expression 'Score > 0\012\012SELECT 
*\012FROM Cases\012WHERE Weighted_Score > 0'."

Don

---------Included Message----------
Date: Tue, 27 Mar 2001 16:48:29 -0800
From: "Andy McKay" <andym@ActiveState.com>
Reply-To: "Andy McKay" <andym@ActiveState.com>
To: <donald.braman@yale.edu>, <zope@zope.org>
Subject: Re: [Zope] multiple SQL commands over ODBC

What error are you getting?

Cheers.
--
Andy McKay.


----- Original Message ----- 
From: "Donald Braman" <donald.braman@yale.edu>
To: <zope@zope.org>
Sent: Tuesday, March 27, 2001 4:31 PM
Subject: [Zope] multiple SQL commands over ODBC


> I'm trying to get two SQL commands that work seperately to work in the 

> same ZSQL Method. The commands are Zope ZSQL -> ZODBCA -> MSODBC -> 
> MSAccess:
> 
> Update Cases
> SET Weighted_Score = 123 (this is a dummy number, just to test)
> WHERE Score > 0
> 
> SELECT *
> FROM Cases
> WHERE Weighted_Score > 0
> ORDER BY Weighted_Score
> 
> Both work seperately; I've also tried inserting a semicolon after the 

> first and both commands. Any ideas? 
> 
> Donald Braman
> donald.braman@yale.edu
> 
> 
> 
> _______________________________________________
> 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 )
> 

---------End of Included Message----------

Donald Braman
donald.braman@yale.edu