CASE
WHEN columnProperty(object_id(quotename(col.TABLE_SCHEMA)+'.'+quotename(col.TABLE_NAME)), col.COLUMN_NAME, 'IsIdentity') > 0 THEN 'true'
ELSE 'false'
END AS [identity],
I tested with a normal SQL Server database that didn't have multiple schemas and it seems to work fine. We'll submit this to Doug as well as a bug fix/addition for additional testing.
Regards,
Brian
On 8/24/06, Chris Dawes <[EMAIL PROTECTED]> wrote:
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
