|
Hi All, I'm new to Reactor and have been having some trouble. I'm sure there is a simple answer but all my searching has failed to find one, so... In a nutshell: Basically I have a MS SQL Server 2000 database with many old and poorly structured tables. Many of these tables have a 'timestamp' column. See: http://www.mail-archive.com/[email protected]/msg01382.html for more info. The timestamp columns are used internally by SQL Server and are not needed/used otherwise so I would really like to just ignore them and this is the problem, I can't find a way to ignore them. Any save() on the reactor record will cause an error and so I'm back to using cfquery until I can solve this. Here are the details of the problem. Server Details: Coldfusion MX 7.0.0.91690 Enterprise SQL Server 2000 Table Details: CREATE TABLE dbo.svc_sip_voip_acct ( data_id int IDENTITY(1,1) NOT NULL, crid int NOT NULL, d_custid int NOT NULL, d_active char(1) NOT NULL, timestamp timestamp NULL, phnumber varchar(10) NULL, username varchar(10) NULL, password varchar(10) NULL ) CF Details: <cfset instanceData.sipVOIPAccount = variables.reactorFactory.createRecord("SIPVOIPAccount") /> <cfset instanceData.sipVOIPAccount.setcrid(#arguments.custRate.getID()#) /> <cfset instanceData.sipVOIPAccount.setd_custid(#arguments.customer.getID()#) /> <cfset instanceData.sipVOIPAccount.setd_active("Y") /> Error: Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Disallowed implicit conversion from data type datetime to data type timestamp table 'plat.dbo.svc_sip_voip_acct' column 'timestamp'. Use the CONVERT function to run this query. ErrorCode HY000 Message Error Executing Database Query. NativeErrorCode 260 Any help/suggestions would be greatly appreciated! Thanks, Bart Lea -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- |
