RE: [Reactor for CF] SQL Express Problem?

[christian briggs]

As predicted, it is not a SQL Express problem (tested it on SQL 2005 Enterprise today with same results).  Just thought I’d confirm.  I’ll look elsewhere for the problem.   cb   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hughes Sent: Saturday, June 17, 2006 11:44 AM To: reactor@reactorframework.com Subject: RE: [Reactor for CF] SQL Express Problem?   FYI, I’ve been using reactor on SQL 2005 (standard and enterprise) for months.  I suspect this is not Express related, but we’ll see.   Thanks,   Doug   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of christian briggs Sent: Saturday, June 17, 2006 11:17 AM To: reactor@reactorframework.com Subject: [Reactor for CF] SQL Express Problem?   I’ve tried creating a very simple scaffold for my own database, as well as the sample reactorblog database.  The list methods for all tables works fine (?event=category.list), but upon committing (from the default scaffold form - ?event=category.edit), I receive the error included below: I’m wondering if this is a specific problem with the database metadata for SQLExpress, that causes problems in the DAO?  Line 72 of the generated DAO.cfc (the line that appears to be throwing the exception) is:                                     <cfif Convention.supportsMultiStatementQueries() AND Convention.supportsIdentity() >                                                 #Convention.lastInsertedIdSyntax(getObjectMetadata())#                                     </cfif>  I’m going to try installing this and running it on a SQL 2000 to try and replicate the problem.  In the meantime, if anyone has a quick idea, please send it along! Cheers, Christian Briggs   Oops! Message   Detail   Extended Info   Tag Context C:\core\CFFrameworks\reactor\project\btapp2\Dao\CategoryDao.cfc (72) C:\core\CFFrameworks\reactor\project\btapp2\Dao\CategoryDao.cfc (15) C:\core\CFFrameworks\reactor\base\abstractRecord.cfc (111) C:\core\CFFrameworks\reactor\base\abstractRecord.cfc (102) C:\core\CFFrameworks\reactor\base\abstractRecord.cfc (92) C:\core\CFFrameworks\ModelGlue\unity\orm\ReactorAdapter.cfc (390) C:\core\CFFrameworks\ModelGlue\unity\controller\ReactorORMController.cfc (129) C:\core\CFFrameworks\ModelGlue\unity\listener\Listener.cfc (26) C:\core\CFFrameworks\ModelGlue\unity\eventrequest\MessageBroadcaster.cfc (32) C:\core\CFFrameworks\ModelGlue\unity\framework\ModelGlue.cfc (310) C:\core\CFFrameworks\ModelGlue\unity\framework\ModelGlue.cfc (268) C:\core\CFFrameworks\ModelGlue\unity\framework\ModelGlue.cfc (241) C:\core\CFFrameworks\ModelGlue\unity\ModelGlue.cfm (47) C:\Inetpub\wwwroot\btapp2\index.cfm (33)   -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --