[Zope] multiple SQL commands over ODBC

Tom Jenkins tjenkins@devis.com
Tue, 27 Mar 2001 20:38:40 -0500


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