4 Replies Latest reply: Mar 29, 2012 12:18 PM by ion RSS

    simple oracle query not working in cf9

    ion Community Member

      when running in oracle 10g, this query returns correctly one row:

       

      WITH myResults  AS

      (

         SELECT 1 AS myLevel, 'someString' AS myData

         FROM dual

      )

      SELECT *

      FROM myResults;

       

      Returns:

       

      MYLEVELMYDATA
      1someString

       

      When put inside a cfquery on a cf9 page, returns nothing!

       

      <cfset qryRan = "false">

      <cfif isDefined('myQry.recordCount')>

          <cfset qryRan = "true">

      </cfif>

      Qry: <cfoutput>#qryRan#</cfoutput>

       

      Returns:

      Qry: false