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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
