Hello, I am working on a shopping cart, using the stable version of web2py, with an sql lite database.
In a checkout function, the order information is being inserted into a sales db,(for example it has db.sales[id] == 2 then in a buy function, after a user enters their card information in order to buy the item, I want to insert an invoice number. I haven't used dbcommit(). If I use db.sales.insert(invoice=invoice), this creates a new record, db.sales[id] == 3 , with just the invoice number in it. I get an error if I try db.sales.append(invoice=invoice). I see in the book that it's possible to try an update with something like this: db.sales[id]=dict(invoice=invoice) but if I try that literal example it is still creating a new record and not updating the current session sales id record. How do I select the id of the current user's record and then use this update example as shown in the book to insert an invoice number into the db.sales record that has been recently created? or how do I append a update to a record? Do I use rollback or something else? Thanks for suggesions. Margaret --
