develooper Front page | perl.beginners | Postings from April 2002

RE: simple problem

From:
Jackson, Harry
Date:
April 29, 2002 09:00
Subject:
RE: simple problem
Message ID:
2393E655560CCA47B87502C5E182CFF3580844@lonexc02.uk.eu.colt


>-----Original Message-----
>From: Sun-hee Kim [mailto:sunhee@aesop.com]
>
>if ( $tablename > 1){
> 
>$sth = $dbh->prepare("SELECT * from $tablename") || die "3: " 
>. $dbh->errstr;


Not sure if you have to or not but don't you need 

$sth->prepare(); 


before execution or is that only Oracle. Is there any error output.


>$sth->execute();
> 
>while (my @data = $sth->fetchrow_array){


*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. +44 20 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or 
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message.  Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************




nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About