binding column names

2004-07-05 Thread Guenter . Buehrle
Hi everybody, what I want to do is something like $dbh->prepare('UPDATE table SET ? = ? WHERE id=?'); $dbh->execute($column,$value, $id); The encountered problem relates to the bind-process of $column. As I suppose I have to explicitly call the bind_param-method the tell the driver not to quote

Query to a MS-Access 97 database using DBD::ODBC driver

2004-01-21 Thread Guenter . Buehrle
I have problems retrieving data from a Microsoft Access 97 database using DBD::ODBC. Using the code ... $sth = $dbh->prepare("SELECT table.id,table.field FROM table WHERE (((table.field) Like \'${variable}*\'));"); $sth->execute; $sth->dump_results(); ... leads to "0 r