> On 9/24/05, Rick Root <[EMAIL PROTECTED]> wrote: >> My problem is with the auto_increment columns. I edit >> my CREATE statement to set the identity property, and >> the create works fine but the data load fails. > > My guess is that you're having problems getting the > identities set > from the existing data? If so, you'll need to do this:
> SET IDENTITY_INSERT myTable ON > 'Do your insert > SET IDENTITY_INSERT myTable OFF Man do I hate identities... I've been working with CF for 7 years and almost every place I've worked has used identities and at almost every job they've caused MAJOR headaches for one reason or another... Even now they still cause headaches at my current job -- no real solution, just a god-awful work-around... s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219181 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
