Bug #5768 for DBIx-LazyMethod: Problem with parameters

Tue Mar 23 09:12:30 2004 jonasbn [...] io.dk - Ticket created

To:	bug-dbix-lazymethod [...] rt.cpan.org
From:	Jonas B.Nielsen <jonasbn [...] io.dk>
Subject:	Problem with parameters
Date:	Tue, 23 Mar 2004 15:12:24 +0100

Hep, I have encountered yet another problem: The following method: drop_db => { sql => "DROP DATABASE ?", args => [ qw(database_name) ], ret => WANT_RETURN_VALUE, } Called like the following: ok($db->drop_db(database_name => 'test')); Fails with the following error also with the DBD::Pg driver. DBD::Pg::st execute failed: ERROR: syntax error at or near "'test'" at character 72 at /Library/Perl/5.8.1/DBIx/LazyMethod.pm line 352. This is my line 352 in DBIx::LazyMethod: #do it my $rv = $sth->execute(@bind_values) or return $self->error("_sth_".$meth." execute failed : ".DBI::errstr); DBI::LazyMethod version 1.02 DBD::Pg: 1.32 jonasbn

Tue Mar 23 17:17:53 2004 cwg [...] usr.bin.dk - Requestor JONASBN added

Tue Mar 23 17:17:59 2004 cwg [...] usr.bin.dk - Requestor jonasbn@io.dk deleted

Tue Mar 23 17:18:04 2004 cwg [...] usr.bin.dk - Taken

Wed Mar 24 09:22:23 2004 cwg [...] usr.bin.dk - Status changed from 'new' to 'open'

Thu Apr 01 12:40:08 2004 cwg [...] usr.bin.dk - Correspondence added 2 min

Hi, The problem has been resolved in the DBIx-LazyMethod 1.03 release, now available on CPAN. Please use the declaration options: -noprepare -noquote to solve your problem. Thank you for submitting! /casper [jonasbn@io.dk - Tue Mar 23 09:12:30 2004]: Show quoted text

> Hep, > > I have encountered yet another problem: > > The following method: > > drop_db => { > sql => "DROP DATABASE ?", > args => [ qw(database_name) ], > ret => WANT_RETURN_VALUE, > } > > Called like the following: > > ok($db->drop_db(database_name => 'test')); > > Fails with the following error also with the DBD::Pg driver. > > DBD::Pg::st execute failed: ERROR: syntax error at or near "'test'"

at Show quoted text

> character 72 at /Library/Perl/5.8.1/DBIx/LazyMethod.pm line 352. > > This is my line 352 in DBIx::LazyMethod: > > #do it > my $rv = $sth->execute(@bind_values) or return > $self->error("_sth_".$meth." execute failed : ".DBI::errstr); > > DBI::LazyMethod version 1.02 > DBD::Pg: 1.32 > > jonasbn >

Thu Apr 01 12:40:09 2004 cwg [...] usr.bin.dk - Status changed from 'open' to 'resolved'