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