I'm actually not involved in the project. I had to back out. I over committed my time and something had to give.
The best thing to do right now is log a bug and attach a patch, if you have one. Someone will review it and publish a fix asap. Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Dawes Sent: Thursday, August 24, 2006 11:23 PM To: [email protected] Subject: RE: [Reactor for CF] dot notated table access Note that SQL 2005 has multiple schemas (cough cough) where SQL 2000 and previous had only one. Cheers, Chris Dawes -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matt Williams Sent: ostirala, 2006.eko abuztuak 25 01:48 To: [email protected] Subject: Re: [Reactor for CF] dot notated table access On 8/24/06, Doug Hughes <[EMAIL PROTECTED]> wrote: > Ah ha. I see your point. I wondered about this. So, your DB has two > Foo tables in different schemas. Yuck. > > Matt seemed to say that the schema wasn't showing up in from statements. > That might be an issue with the specific dbms. Which DBMS is being > used your project, Matt? It should "just work" in MSSQL. SQL Server 2005 > > Are these both correct? If so, the easiest solution is an additional, > optional, argument in the <object> tag to define the schema / owner. Correct about the From statement. I can override the from statement, hard code it an get the query results. In regards to the project, Doug, this is Sami's project you are partially involved in. You have access to their SVN which is where I put my modifed reactor code if you care (or can find the time) to take a look. Basically in the reactor\data\mssql directory I modified Convention.cfc and objectDAO.cfc to treat the dot-notated object name as a list and sort things out. -- Matt Williams "It's the question that drives us." -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
