>It is a bug because it works differently from cf7. Not in my opinion. cfquery is only supposed to return one resultset. So to me that makes CF7's behavior a fluke/wrong. Yes, you can run multiple statements inside a cfquery, but I do not think it was intended as a replacement for stored procedures where you can run multiple statments and return multiple resultsets.
>And the issue seems to be not that cf is returning the wrong resultset (ie >rowcount instead of the identity), it's that it's not returning any >resultset at all. It is not returning a CF _named_ query. That is different than not returning any results. There is nothing that says a cfquery statement has to return a resultset (ie query with data). An UPDATE statement does not. I think you may be confusing the two. The first insert returns a rowcount. CF is treating that as a result. But since a rowcount is not a resultset (ie query with data), that is why your query variable is undefined. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
