I cannot get a MS-SQL coldfusion datasource to work correctly using auto-increment (identity = yes). MS Access seems to handle Autonumber just fine however.
I let the CF Wizard generate my component scripts and there's an option to allow the primary key to be handled by the user if the database won't auto-increment. Well, I'd like to use this option, but I don't know what needs to be done after the scripts are generated.
Can anyone provide some insight on what code needs modified?