Did something change with how the new ZSybaseDA handles the results from a Sybase stored procedure? I noticed that with the 'Test' tab on the ZSQL Method that the results are quite different with Zope2. Zope1 just returned the simple key/value results. Zope2 returns keys called: Query, Status, and Calls. With the results hidden in Status. Is there a way to get the old behavior? thanks -- -chad
Hi Chad, I added execute_m=regex.compile('[\0- ]*execute[\0- ]+',regex.casefold).match to the beginning of the query() method in db.py, and then added this to a later part of the same function: r=c.execute(query_string) result=c.fetchmany(max_rows) desc=c.description[0] + elif execute_m(query_string) >= 0: + result=db.execute(query_string)[0] + desc=db.description[0] else: r=db.execute(query_string) Sorry this isn't a real patch, I'm in kind of a hurry now. I don't know if this is the best way to do this, but in the meantime at least it gives some results! --Brian
participants (2)
-
Brian Hooper -
Chad McDaniel