28 Mar
2001
28 Mar
'01
12:31 a.m.
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