RE: [Reactor for CF] Multiple Databases With Reactor

[Fawad Sami]

I’ve heard ‘Reactor 2’ being mentioned in relation to this.   I haven’t tried this though one suggestion in the meantime (provided your multiple databases are on the one server) is to create a datasource in CFAdministrator without specifying a database and then in your two databases (eg mydatabase1, mydatabase2), prefix all table names with the database name (eg mydatabase1_mytable1, mydatabase2_mytable1) so as to ensure if you have any tables with the same name across the multiple databases, that you can reference them uniquely in the Reactor.xml file (eg <object name="mydatabase1_mytable1">, object name="mydatabase2_mytable1">).   As I said, I don’t know if this will work however it will affect me soon as well so PLEASE let me know if this suggestion helps!   Fawad Sami IT Team Lead ICLP Sydney   This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its content to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of International Customer Loyalty Programmes Pty Ltd and its associated companies. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Blatz Sent: Tuesday, 31 October 2006 8:15 AM To: reactor@reactorframework.com Subject: [Reactor for CF] Multiple Databases With Reactor   I’m starting a project that will require me to access tables from multiple databases.  How can I do this with reactor, the best solution I’ve come up with so far is to create views to the tables I need.  Is there anyway to pass the full table name (myserver.mydatabase.mytable) to reactor?   Ryan Blatz Systems Developer/Engineer College of Education and Human Ecology - The Ohio State University   -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --