When you want to get an ID field of a record that was just inserted, you have to use the code below in ColdFusion.  First you "SET NOCOUNT ON" and process your insert statement.  After the insert, use a select statement like the following "SELECT @@IDENTITY AS varname".... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5