Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Andy Weber and Gunnar Lieb and Thilo Hermann
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Andy Weber , Gunnar Lieb@akitogo ) , and Thilo Hermann ( @thfusion_de )

Mark P.

Member since Oct 12, 2011

Recent Blog Comments By Mark P.

  • Getting @@RowCount After SQL INSERT INTO Statement

    Posted on Oct 12, 2011 at 9:58 AM

    Looks like this is an old topic. But to add to it: <cfquery .... result="qryResult"> ...SQL LOGIC </cfquery> qryResult.IDENTITYCOL should contain new ID of an inserted row qryResult.RecordCount (for an update or insert I assume) will give you the number of rows affected.... read more »