Tag: CFQuery

I run it in my cfquery.

SET @rID = (SELECT TOP 1 roleid
FROM Roles
WHERE RoleName = @rName AND appid = @appID
ORDER BY Created DESC); Is it possible to retrieve @rID without having to run