Any create, drop, insert, truncate, delete, or update operation has to be commited:
db.commit() On May 2, 8:23 am, Brian <[email protected]> wrote: > Hello everyone, > I'm developing a simple database app locally with SQLite. Everything > works great. When I push to the server, it's using Postgres and when I > do this: > > ... > def update(): > recordId = request.vars.id > updatedField = request.vars.updatedField > updatedData = request.vars.updatedData > > row = (db.part.id == recordId) > if updatedField == 'part_Number': > db(row).update(part_Number = updatedData) > ... > > The row updates fine, but isn't visible with a: > > db().select(db.part.ALL) > > I can go into web2py's database admin and point directly to a row's ID > and it pulls up fine, it just doesn't show up with the rest of the > rows on a SELECT ALL. I can also use pgAdmin3 (postgres admin tool for > Mac) and see the data fine. I've also tried doing a: > > db.part[recordId].update_record(part_Number = updatedData) > > But it has the same effect. So my questions are as follows: > 1) What am I doing wrong with the above? > 2) What's the difference between an update and an update_record? > 3) With the above example, is there anyway I can use a variable for a > field name? So instead of having a bunch of if's and elif's to go > through the field, I could do a: > db(row).update(updatedField = updatedData) > > Thanks! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" 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/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
