Matt/Doug, Could one of you add the revised reactor\data\mssql files to ticket 42 ( http://trac.reactorframework.org/reactor/ticket/42 )?
Thanks, beth
On 8/24/06, Matt Williams <[EMAIL PROTECTED]
> wrote:
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
