Hi everyone,
I've got a little problem which I can't find anything about.
I'm trying to call a stored procedure via SA, which works fine (at least the
calling part does), but the transaction is rolled back.
Looking into the database logfile (postgresql) I don't see any errors on the
database end while performing the query, however TG issues an ABORT.
So the question is, how can I make TG issue a commit instead. Is there some
additional parameter or something?
Here's the relevant model code:
proc_save_email=select(['*'],
from_obj=[func.save_email(bindparam('uid'),
bindparam('handle'),
bindparam('subject'),
bindparam('message'),
bindparam('as_draft'),
bindparam('photo1'),
bindparam('photo2'),
bindparam('photo3')
)],
engine=engine
)
def
PsaveEmail(uid=0,handle='',subject='',message='',as_draft=0,photo1='',photo2='',photo3=''):
"""save an email """
rv=proc_save_email.execute(uid=uid,
handle=handle,
subject=subject,
message=message,
as_draft=as_draft,
photo1=photo1,
photo2=photo2,
photo3=photo3)
return rv
Any pointers are greatly appreciated.
Uwe
--
Open Source Solutions 4U, LLC 1618 Kelly St
Phone: +1 707 568 3056 Santa Rosa, CA 95401
Cell: +1 650 302 2405 United States
Fax: +1 707 568 6416
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
