I like the new feature of getting Identity column value from cfquery in CF*, saved me couple of line of code to get the value from SCOPE_IDENTITY() (MS SQL system variable), you just got to put result name in cfquery tag and then you can get it as resultname.IdentityCol, there is one restriction, you should have just one insert statement in that cfquery, when I had one local query lookup which was saving its result in local @VAR then this IdentityCol thing didn't work.
let me know if you are not clear about what I am saying, LOL
No comments:
Post a Comment