Hello all,
Hope this is easy to replicate.
After connect, my code:
my $sth = $dbh->prepare( "select fname, lname, addr, city, state from
person");
# my $sth = $dbh->prepare( "select fname, lname from person");
$sth->execute;
$sth->bind_columns( \$f, \$l, \$a, \$c, \$s );
# $sth->bind_columns( \$f,
On Thu, 19 Dec 2002, Jeff Urlwin wrote:
> I don't see a "fetch" in the below code ... My recommended spot would be
> below
Thanks Jeff. Your message made it into the dbi folder and Michael Chase's
to my inbox. I saw his first.
This was the problem.
Best,
Rod
--
"Open Source Software - Som
On Thu, 19 Dec 2002, Michael A Chase wrote:
> Note that bind_columns() does not fetch the rows, it just defines where the
> columns will be stored when a row is fetched.
Bingo!!!
The example in the Cheetah book assumes a return of more than one row. I
wasn't so I didn't use that part of the co
On Thu, 19 Dec 2002 13:37:28 -0800 (PST) "Roderick A. Anderson" <[EMAIL PROTECTED]>
wrote:
> Here it is with all the cruft from trying to sort it out. I haven't
> included the connect stuff or the rest of the script since I know it
> works.
> my $sth = $dbh->prepare($domain_qry);
>
>
>
>
> On Thu, 19 Dec 2002, Michael A Chase wrote:
>
> > The devil is often in the details. A snippet from the
> actual script
> > that demonstrates the problem would make it much easier for
> us to help
> > figure it out.
>
> Yeah I was trying to hold the bandwidth down but have just upped
On Thu, 19 Dec 2002, Michael A Chase wrote:
> The devil is often in the details. A snippet from the actual script that
> demonstrates the problem would make it much easier for us to help figure it
> out.
Yeah I was trying to hold the bandwidth down but have just upped it
instead.
Here it is wi
On Thu, 19 Dec 2002 11:19:10 -0800 (PST) "Roderick A. Anderson" <[EMAIL PROTECTED]>
wrote:
> I'm having a problem with bind_columns or possibly my understanding
> of the returned values. Using the syntax in the Cheetah book and at CPAN
> I get empty scalars when all my testing indicates there
I'm having a problem with bind_columns or possibly my understanding
of the returned values. Using the syntax in the Cheetah book and at CPAN
I get empty scalars when all my testing indicates there should be a
values.
PostgreSQL 7.2.1 (from RPM), Perl 5.6.1 (RPM), DBI 1.30 (tarball),
DBD-Pg-1.0