Re: cfinsert works with mySQl 5 but NOT with ms sql server 2005

["paross1" <webforumsuser@xxxxxxxxxxxxxx>]

I never use cfinsert/cfupdate because they have been nothing but a buggy mess 
since I've been involved with ColdFusion, but your problem may be related to CF 
not being able to determine what your primary key fields are, etc. When you 
converted from MySQL to MSSQL, how did you handle the PK fields? Are they 
defined as such? Were they created with the IDENTITY property, etc.?

 I have always used cfquery tags and SQL UPDATE and INSERT statements because 
they offer much more control, and cfinsert/cfupdate just plain suck, so I don't 
have a lot of advice to offer.

 Sorry,
 Phil