I'm stuck again! I'm on pset7 'buy' and think I'm almost done - it's deducting the stock price from the 'users' table fine, but when I try to insert the data into the 'transactions' table I get an error msg "RuntimeError: (sqlite3.OperationalError) no such column: user [SQL: "INSERT INTO 'transactions' (users_id, symbol, number, price, date, total_cost) VALUES (user, symbol, quantity, price, datetime('now'), total)"]
I don't understand why it's saying there's no 'user' column when 'user' is in the VALUES brackets - it's a variable that I declared earlier in the code so I could use it here - not a column...I've fiddled around with the order but I just get a different error saying I can't use the datetime bit (it calls it an undeclared var)....I'm not 100% sure the problem isn't with the datetime bit as I found how to use it right (I think!) online but there's no indication in the cs50 docs about it...
Any help would be so appreciated - Thank you!!
Here's my 'buy' code: http://pastebin.com/HiPmy952