Please add a ticket for this at http://trac.reactorframework.org/reactor. If you attach a "create table" script, it would be helpful.
Beth
On 9/19/06, Hayes, Kyle D <[EMAIL PROTECTED]> wrote:
Good Morning Everyone,The issue I am having is I converted one of my tables that was previously using a standard integer auto increment id as the PK to a uniqueidentifier. The reason why I chose the uniqueidentifier datatype is because I saw an earlier post in the archives that Reactor would be able to tell the difference. Unfortunately, it is causing me issues. The strange part about it, is that it is inputting the data into the table but it throwing an error somewhere, here is the code I am using:<cfset
documentRecord = variables.reactorFactory.createRecord("employeeStepDocuments") /> <cfset documentRecord.setBemsId(stepRecord.getBemsId()) /> <cfset documentRecord.setStepId(stepRecord.getStepId()) /> <cfset documentRecord.setFileName(cffile.ServerFileName) /> <cfset documentRecord.setFileExt(cffile.serverFileExt) /> <cfset documentRecord.save() /><cftry>
<cfset stepRecord.getEmployeeStepDocumentsIterator().add(documentRecord) /> <----------- This is where the error is happening
------------------------
SQL
------------------------SELECT [employeeStepDocuments].[fileId] AS [fileId], [employeeStepDocuments].[stepId] AS [stepId], [employeeStepDocuments].[bemsId] AS [bemsId], [employeeStepDocuments].[fileName] AS [fileName], [employeeStepDocuments].[fileExt] AS [fileExt] FROM [employeeStepDocuments] AS [employeeStepDocuments] WHERE [employeeStepDocuments].[stepId] = (param 1) AND [employeeStepDocuments].[bemsId] = (param 2)
------------------------
Misc
------------------------
The error seems to be coming from the GETBYQUERY.runFunction(C:\Inetpub\wwwroot\reactor\base\abstractGateway.cfc:603)
If you need any other information please let me know.Kyle Hayes
Web Developer / Programmer
WebAID - Anaheim
Boeing Information Technology
714.762.2894
[EMAIL PROTECTED]
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
