We have a userUId column of type uniqueidentifier in our MS SQL database. We are running into some issues where sometimes the UID's are cut off when passed in url's (from email clients, etc). I think the problem may be the - character, where certain email clients and browsers decide to chop things off at the - character.
So we've decided to create another column, userStrUid of type varchar, and set the formula to (left(replace([userUId],'-',''),40)). Now this works as expected, and it populated data for all exisiting users for this field. Now, however, when I do inserts, I get this error: [Macromedia][SQLServer JDBC Driver][SQLServer]INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'. I am not using this column on the insert, and there is no default set (should there be?). Also the primary key is inserted by getting a max(userid) + 1 and then inserting it. I'd like to switch it to an identity column, but wondering if that will mess up my data. I've taken out the column and the insert works fine now. Why is it failing? Russ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211686 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
