Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

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 »