Hi, I just started trying to figure out SQLAlchemy today as I was hoping to translate my current SQL queries into a database agnostic format. I admit that this OO way is kind of confusing to me. Anyway, my question is how do I translate the following SQL statement into SQLAlchemy format?
sql = " UPDATE tbl_TimeEntries SET %s = %s WHERE dateworked = '%s' " % (fieldName[x], value, dbDate) I''ve been reading and re-reading the official docs and skimming the tutorials most of the day, but it seems that I somehow need to know what column name I am going to update ahead of time, which isn't really possible in my case as this is for a timesheet application I created using wxPython as the frontend and the user can update any column they want in any order. The SQL statement above works; I would just like to use SQLAlchemy instead. I am currently using Python 2.5 (and 2.4 occasionally) on Windows XP with SqlAlchemy 0.4.2b. Thanks! Mike --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
