Full CFScript CFCs Aren’t Yet Where They Need To Be

query-script.cfm

local.queryService = new Query(datasource=get('dataSourceName'));
local.queryService.setSql("
    SELECT DISTINCT
        A.*
    FROM
        apps A
        JOIN appgroupmemberships G
            ON A.id = G.appid
        WHERE
            G.usergroupid IN (#local.groupIds#)
            AND deletedat IS NULL
");
local.apps = local.queryService.Execute().GetResult();

query-tag.cfm

<cfquery datasource="#get('dataSourceName')#" name="local.apps">
    SELECT DISTINCT
        A.*
    FROM
        apps A
        JOIN appgroupmemberships G
            ON A.id = G.appid
    WHERE
        G.usergroupid IN (#local.groupIds#)
        AND deletedat IS NULL
</cfquery>