RE: [Reactor for CF] SQL Express Problem?

[christian briggs]

Thanks for the quick reply.  That helps immensely.  Perhaps it has to do with the way I’m calling it in the MG2:Unity framework (see below from my modelglue.xml file).  I’ll try a few things and post what I find:   <modelglue>             <controllers>                         <controller name="MyController" type="btapp2.controller.Controller">                                     <message-listener message="OnRequestStart" function="OnRequestStart" />                                     <message-listener message="OnQueueComplete" function="OnQueueComplete" />                                     <message-listener message="OnRequestEnd" function="OnRequestEnd" />                         </controller>             </controllers>               <event-handlers>             <scaffold object="user" />             <scaffold object="rating" />             <scaffold object="entry" />             <scaffold object="category" />…………………….etc.     Cheers, 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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --