Hello.
On Fri, Feb 09, 2001 at 09:53:45AM -0500, [EMAIL PROTECTED] wrote:
> Good Morning:
>
> We have a system of databases (in the plural) which number in the hundreds
> on individual servers. I want to open a persistant connection on the server
> and switch databases without closing the handle in DBI and reopening it.
The SQL command "USE database" should work.
> Is this possible without getting a rollback warning using DBI?
Hm. What is the exact message? Do you use BDB tables? If yes, maybe an
explicit COMMIT helps? (did not use BDB tables myself, yet).
I nothing else help, you can always work-around the problem by
explicitly stating the database name in your queries (which is not
pretty, but works), like
SELECT * FROM mydatabase.thetable WHERE <some condition>
Bye,
Benjamin.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
