Assuming you've established a connection...
@result = $dbh->selectrow_array("SELECT DISTINCT column1 FROM table
WHERE column2= -1");
$dbh->disconnect;
This should do...
Babs
||> -----Original Message-----
||> From: McMahon, Chris [mailto:[EMAIL PROTECTED]
||> Sent: Wednesday, May 05, 2004 12:46 AM
||> To: [EMAIL PROTECTED]
||> Subject: Simple DBI question
||>
||>
||> Hello...
||> My first DBI script was simply an inventory of columns in
||> tables.
||> Now I'm struggling with my second DBI script, and finding the
||> CPAN docs tough going.
||> Can anyone suggest DBI syntax to capture the result of
||>
||> SELECT DISTINCT column1 FROM table WHERE column2= -1
||>
||> into an array? Just a hint would help...
||> -Chris
||>
||> --
||> To unsubscribe, e-mail: [EMAIL PROTECTED]
||> For additional commands, e-mail: [EMAIL PROTECTED]
||> <http://learn.perl.org/> <http://learn.perl.org/first-response>
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
