Re: Retrieving Data from a Db using Perl

2002-07-16 Thread Wiggins d'Anconia
Don't forget the "WHERE" clause in your select statement, and rather than selecting "*" why not ONLY select the email field. And the example is connecting to an Oracle DB not an Intersolv DB, unless they are the same (sorry I am not familar with Intersolv). *If* you are only looking to do a s

RE: Retrieving Data from a Db using Perl

2002-07-16 Thread Rajaraman_Seetharaman
Hi Michael, Try the following code might be useful..in connecting to a database..and retrieving value... $dbh = DBI->connect("DBI:Oracle:$dbname", $user, $options, {AutoCommit=>0}) $statement = "Select * from emp" $sth = $dbh->prepare($statement) $sth = $dbh->prepare($statement, {