binding column names

From: Guenter Buehrle (Guenter.Buehrle_at_MarconiSelenia.com)
Date: 07/06/04 

To: dbi-users@perl.org
Date: Tue, 6 Jul 2004 08:33:34 +0200

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 the column-name.
Is that right? Which kind of SQL-type do I have to assign to it?

Thank You.

Günter Bührle

Relevant Pages

  • Re: binding column names
    ... The encountered problem relates to the bind-process of $column. ... Which kind of SQL-type do I have to assign to it? ... Günter Bührle ...
    (perl.dbi.users)
  • Re: binding column names
    ... > The encountered problem relates to the bind-process of $column. ... drivers support it). ... or long term contract positions - http://www.peppler.org/resume.html ...
    (perl.dbi.users)