I would
$dbh -> {RaiseError} = 1;
my $sth = prepare();
$sth -> execute( ... );
$sth -> bind_columns( \( ... ) );
while ( $sth -> fetch ) {
}
They are all described in the fine manual (perldoc DBI).
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Rozengurtel, Daniel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2001 09:19
Subject: SELECT
> I need to run this select statement:
> select ISID.instr_id, ISDE.iss_desc from FT_T_ISID ISID, FT_T_ISDE ISDE
> where ISID.ID_CTXT_TYP='BBTICKER' and ISID.instr_id=ISDE.instr_id
> which invokation method should I use? ( it has to return a lot of
records)?