yes this will work. Infact you can process data of multiple databases by separately logging onto them as long as the handles are kept separate.
regards adrian -----Original Message----- From: Will [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 2:14 PM To: DBI Users Subject: Multiple SQL commands in a scripts? Greets Folks, I havent tried this yet, but I was wondering if it is possible to use multiple SQL commands in a list... maybe something like so... ###PREPARE AND RUN THE FIRST SQL COMMAND#### my $sth = $dbh->prepare("SELECT foo FROM bar"); my $thing = $sth->execute(); ###PREPARE AND RUN A SECOND SQL COMMAND BEFORE DISCONNECTING### my $sth = $dbh->prepare("SELECT jabba FROM yadda"); my $anotherthing = $dbh->execute; There's probably mistakes in my code, but the idea seems clear enough. My question is whether it will work, or how I can make it work? Also, awhile back I recall hearing someone say I shouldnt use $sth->exit(); with mod_perl, and I was wondering if this is true? Or, if it is, why? Thanks, Will __________________________________________________ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com
