Bug #42733 for SQL-Interp:

Fri Jan 23 15:11:51 2009 metaperl [...] gmail.com - Ticket created

Re: http://search.cpan.org/~markstos/SQL-Interp-1.06/lib/SQL/Interp.pm#Preparing_and_reusing_a_statement_handle We read: my $sth; for my $href (@array_of_hashrefs) { my @list = ('SELECT * FROM mytable WHERE', $href); my ($sql, @bind) = sql_interp @list; if (! defined $sth || $sth->{Statement} ne $sql) { $sth = $dbh->prepare($sql); } $sth->execute(@list); ###### <------ SAY WHAT?!!!!! $sth->fetchall_arrayref(); } but the ->execute() should be against @bind not @list

Fri Jan 23 18:03:01 2009 mark [...] summersault.com - Correspondence added

Subject:	Re: [rt.cpan.org #42733]
Date:	Fri, 23 Jan 2009 15:15:49 -0500
To:	bug-SQL-Interp [...] rt.cpan.org
From:	Mark Stosberg <mark [...] summersault.com>

Show quoted text

> Re: > http://search.cpan.org/~markstos/SQL-Interp-1.06/lib/SQL/Interp.pm#Preparing_and_reusing_a_statement_handle > > We read: > > my $sth; > for my $href (@array_of_hashrefs) { > my @list = ('SELECT * FROM mytable WHERE', $href); > my ($sql, @bind) = sql_interp @list; > if (! defined $sth || $sth->{Statement} ne $sql) { > $sth = $dbh->prepare($sql); > } > $sth->execute(@list); ###### <------ SAY WHAT?!!!!! > $sth->fetchall_arrayref(); > } > > but the ->execute() should be against @bind not @list

Thanks, Terrence. I'll repair it, with credit to you. Mark

Fri Jan 23 18:03:02 2009 The RT System itself - Status changed from 'new' to 'open'

Sun Jun 28 20:08:49 2009 MARKSTOS [...] cpan.org - Correspondence added

Subject:

thanks

Your other SQL::Interp typo report is soon to be released as a fix.

Sun Jun 28 20:08:50 2009 MARKSTOS [...] cpan.org - Status changed from 'open' to 'resolved'