Re: DBI realted queries

2004-02-04 Thread Wiggins d Anconia
> Hi all, > > > $sth->{LongReadLen} = 3; #what's the statement doing ? And from where > to find out what all parameters are available to statement handle ? > > my ($id_prod); > my $sqlstmt = <<"EOM"; > SELECT > id_prod > FROM > product > EOM > > my $dbh = DBI->connect('D

Re: DBI realted queries

2004-02-04 Thread Eternius
Nilay Puri wrote: Hi all, $sth->{LongReadLen} = 3; #what's the statement doing ? And from where to find out what all parameters are available to statement handle ? my ($id_prod); my $sqlstmt = <<"EOM"; SELECT id_prod FROM product EOM my $dbh = DBI->connect('DBI:Oracle:' . $SID,

DBI realted queries

2004-02-04 Thread Nilay Puri, Noida
Hi all, $sth->{LongReadLen} = 3; #what's the statement doing ? And from where to find out what all parameters are available to statement handle ? my ($id_prod); my $sqlstmt = <<"EOM"; SELECT id_prod FROM product EOM my $dbh = DBI->connect('DBI:Oracle:' . $SID, $USERNAME, $PA