On 11/8/06, Brian Kotek <[EMAIL PROTECTED]> wrote:
Thanks Qasim, I actually created a fix for this and set up a Trac ticket.On 11/7/06, Qasim Rasheed < [EMAIL PROTECTED] > wrote:If I remember correctly there was a similar question in the past regarding computed columns (another SQL server feature - I think) and AFAIK, there was not obvious solution/fix. Here is the url to that thread.
http://www.mail-archive.com/[email protected]/msg02172.html
Thanks,
QasimOn 11/7/06, Brian Kotek < [EMAIL PROTECTED]> wrote: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.
Grants Network Exception
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
