in reply to DBI Update dynamically
Hi, it's not possible to UPDATE without knowing the column names. You could get them via a SELECT prior to your UPDATE.
In any case it would not be a good design to do what you want since your program would break as soon as the DB schema changes with a new column added or one removed, etc.
Hope this helps!
|
---|