Mark P.
Member since Oct 12, 2011
- Profile: /members/9110-mark-p.htm
- URL: http://www.webstaurantstore.com
- Comments: 1
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 »