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