[Zope] multiple SQL commands over ODBC

28 Mar 2001

      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