How can I get the SQL variable from cfquery?

Question

I run this inside my cfquery .

 SET @rID = ( SELECT TOP 1 roleid FROM Roles WHERE RoleName = @rName AND appid = @appID ORDER BY Created DESC); 

Is it possible to get @rID without restarting the SELECT query? How in:

 <cfset varName = queryName.rID> 

The above does not work explicitly, but is there any other way to return a variable from a request?

Answer 1

You can get the @rID select value without having to run the full query again.

 <cfquery name="qryRoleID"> SET @rID = ( SELECT TOP 1 roleid FROM Roles WHERE RoleName = @rName AND appid = @appID ORDER BY Created DESC); SELECT @rID AS rID </cfquery> <cfdump var="#qryRoleID.rID#">