RE: [Reactor for CF] SQL Express Problem?

[Joshua Scott]

Were you using a previous version of reactor before this? I have seen odd stuff like this happen if a new version is installed over an older version.   - JS       ------------------------------------------------ Joshua Scott Resonant Media Technologies, LLC. http://www.resonantmedia.com | http://blog.resonantmedia.com   "It is impossible to get out of a problem by using the same type of thinking that it took to get into the problem." -- Albert Einstein       From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of christian briggs Sent: Saturday, June 17, 2006 10: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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --