: Thursday, January 10, 2002 5:40 PM
To: [EMAIL PROTECTED]
Subject: Re: problems with prepared and bind_param
On Thu, 10 Jan 2002 15:46:26 -0800, Kokarski, Anton wrote:
>Also $sth->execute() returns E0E but there is nothing in $DBI::errstr
Are you sure it's not "0E0"? T
On Thu, 10 Jan 2002 15:46:26 -0800, Kokarski, Anton wrote:
>Also $sth->execute() returns E0E but there is nothing in $DBI::errstr
Are you sure it's not "0E0"? That is: zero but true.
--
Bart.
Anton'; [EMAIL PROTECTED]
Subject: RE: problems with prepared and bind_param
> From: Kokarski, Anton [ mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ]
>
> my $statement = "select count(*) as viewable from pf_funding where ".
>"tar
> From: Kokarski, Anton [mailto:[EMAIL PROTECTED]]
>
> my $statement = "select count(*) as viewable from pf_funding where ".
>"target_id = ? and amt_allocated > 0.01
> and year = '" .
> $self->{year} . "'";
>
Is year always the same value or does it only change once a year
Hi All,
I'm having trouble with using placeholders. I had an sql statement that was
execute using a simple prepare, execute and fetchrow_hashref functions. Now
I'm trying to get it to work with place holders so I can get some
performance increase, since this block of code runs to many times not
