Does an Insert query in CFSCRIPT return an IDENTITYCOL value

Stephen M

unread,

Oct 25, 2012, 10:01:21 PM10/25/12

to cfau...@googlegroups.com

Does an Insert query in CFSCRIPT return an IDENTITYCOL value/

It should be a property of the resultset but I can't get a resultset using getResult() when its an INSERT.

Its OK using the CFQUERY tag. The problem only seems to be in CFSCRIPT.

Zac Spitzer

unread,

Oct 25, 2012, 10:03:34 PM10/25/12

to cfau...@googlegroups.com

are you looking in the the name or the result variable?

> --
> You received this message because you are subscribed to the Google Groups
> "cfaussie" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/cfaussie/-/O74Nb-R-CEQJ.
> To post to this group, send email to cfau...@googlegroups.com.
> To unsubscribe from this group, send email to
> cfaussie+u...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/cfaussie?hl=en.

--
Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
+61 405 847 168

Bill Moniz

unread,

Oct 25, 2012, 10:30:28 PM10/25/12

to cfau...@googlegroups.com

Hey Steve. In CFSCRIPT you use myQueryObj.getPrefix().generatedKey for an insert.

Reply all

Reply to author

Forward