My user_id for a User object in the transfer XML file generates a
GUID:
<object name="User" table="users">
<id name="user_id" type="GUID" generate="true" />
</object>
My MS SQL column Data Type is uniqueidentifier.
This all works completely fine in my ColdBox application until I turn
on HandlerCaching in the ColdBox config file. Then suddenly when I try
to create a new user, or edit an existing user, I get an error like
the following:
Application Execution Exception
Error Type: Database : n/a
Error Messages: Invalid data 224CCA79-FD96-942F-25EE-5B0B90D6181D for
CFSQLTYPE CF_SQL_FLOAT.
Should this all work seamlessly, or am I missing something? Any ideas
what's going on?
Thanks,
Thomas
ID: CFQUERY
LINE: 82
Template: C:\inetpub\wwwroot\transfer\com\sql\QueryExecution.cfc
ID: CF_TEMPLATEPROXY
LINE: 53
Template: C:\inetpub\wwwroot\transfer\com\sql\TransferSelecter.cfc
ID: CF_TEMPLATEPROXY
LINE: 87
Template: C:\inetpub\wwwroot\transfer\com\sql\SQLManager.cfc
ID: CF_TEMPLATEPROXY
LINE: 50
Template: C:\inetpub\wwwroot\transfer\com\dynamic
\TransferPopulator.cfc
ID: CF_TEMPLATEPROXY
LINE: 72
Template: C:\inetpub\wwwroot\transfer\com\dynamic\DynamicManager.cfc
ID: CF_TEMPLATEPROXY
LINE: 120
Template: C:\inetpub\wwwroot\transfer\com\Transfer.cfc
ID: CF_TEMPLATEPROXY
LINE: 18