如何从cfquery中检索SQL变量？

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

是否可以在不必再次运行SELECT查询的情况下检索@rID？
如：

<cfset varName = queryName.rID>

以上显然不起作用,但有没有其他方法从查询中返回变量？

<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#">