check out sql_delimiter in: http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.1.4.4.html Donald Braman wrote:
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 )
-- Tom Jenkins devIS - Development Infostructure http://www.devis.com