<!--- OLDER SQL THAT USED TO WORK--->
        <cfif structkeyExists(url,'event_date')>
                <cfquery name="get_comp_details" dataSource="db9">
                    SELECT nCompetitor as competitor_name, nScore as score, nDate
                    FROM nDataAll
                        WHERE nDate = <cfqueryparam cfsqltype="cf_sql_date" value="#event_date#" />
                    ORDER BY nScore DESC
                    -- LIMIT 27
                </cfquery>
            </cfif>

<!--- Trying to convert it so it can be used in queries of queries---->
<cfset getEventRslts = new Query (
     sql = "Select * From nDataAll WHERE nDate = <cfqueryparam cfsqltype="cf_sql_date" value="#event_date#" />",
      datasource = "db9"
     ) />