[Reactor for CF] Issue When switching over to UUID in SQL Server (2000)

[Hayes, Kyle D]

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
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --