just guessing, but this seems wrong: ``filter_by(id = payment.id)``. shouldn't it be ``filter_by(id == payment.id)``?
andi (sent right out of my head) On 13.04.2013, at 12:12, "Biswas, Pinakee" <[email protected]> wrote: > Hi, > > I need help with SQLAlchemy. I am not sure if this is the right forum to ask > the query but since we are using Pylons and SQLAlchemy is part of the same, I > thought asking here: > > I am using UPDATE query on SQLAlchemy session as follows: > > p = DBSession.query(Paymenttransaction).filter_by(id = > payment.id).update({"status":'success', "transactionid":’transaction_id’]}, > synchronize_session=False) > > p is returning 1 (number of rows matching the query). There is also no > exception thrown. But somehow the columns are not getting updated in the > Database. I am not sure what is going wrong here. > > I have used similar query elsewhere in the code where it is working fine. > > Would really appreciate if you could give me some pointers. > > We are using SQLAlchemy 0.6. Database is MySQL. > > Looking forward to your response and support… > > Thanks, > Pinakee Biswas > Director & CTO > > <image001.jpg> > > 7E- Mail: [email protected] I 8Web: http://www.vvidiacom.com > <image002.png> > > -- > You received this message because you are subscribed to the Google Groups > "pylons-discuss" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/pylons-discuss?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/pylons-discuss?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
