Re: DBI MySQL Use Another DB Without Disconnecting

"afrinspray" <afrinspray@xxxxxxxxx> wrote:
> Is there a way to change the database in a DBI mysql connection without
> disconnecting? For example, in PHP you'd just say
>
> mysql_select_db("db_name_here", $dbh)
>
> I looked through the DBI code on cpan and I didn't see anything, but
> I'm falling asleep here at work, so maybe I missed it. :)

$dbh->do("use $db_name_here");

Unfortunately, placeholders don't work in this context.

Xho

--
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service $9.95/Month 30GB
.