Hi all, we have a SQL Server set up for merge replication, and part of that means specifying a "rowGUID" column to use during the replication. Reactor just sees this as another column, and apparently when it tries to update the field, it's generating a SQL Server error. Anyone run into this or have any ideas? I already have a modified version of the Reactor query that obtains all the column and type information from the system tables to make it include checks for the "isRowGUIDCol" property. I think that based on this I can figure out how to modify what Reactor generates in the DAO to make it omit updates to these columns, but before I went that far I wanted to throw the question out to the group to get your ideas. The error is below. If you have any thoughts please post away! Thanks.
| Request Event |
gn_updateAccount |
| Message |
Error Executing Database Query. |
| Detail |
[Macromedia][SQLServer JDBC Driver][SQLServer]Updating columns
with the rowguidcol property is not allowed. |
| Extended Info |
|
| Tag Context |
E:\webapps\reactor\project\grantsNetwork\Dao\UserDao.cfc
(871) E:\webapps\reactor\project\grantsNetwork\Dao\UserDao.cfc
(13)
|
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --