Bind parameters for SET statements

Alfie John <[email protected]> Thu, 3 Mar 2011 11:25:03 +1100

Newsgroups	gmane.comp.db.mysql.perl
Message-ID	<[email protected]>

Hi,

Not sure if this is a DBD::mysql or a plain DBI problem but thought I
would start here.

It seems that the following code is broken:

  $dbh->do( 'SET TIMESTAMP=?', undef, $timestamp );

This fails with:

  Incorrect argument type to variable 'timestamp'

Yet the following works:

  $dbh->do( "SET TIMESTAMP=$timestamp" );

Alfie

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]