3 Replies Latest reply on May 21, 2007 11:18 AM by insuractive

    QofQ doesnt' see columns

    Mark Forsberg Level 1
      I have a query (q_getResults) that contains a column "myColumn". When I dump the query immediately before my qoq it appears with the data. When I attempt to do a query of queries with q_getResults it tells me:

      The select column reference [myColumn] is not a column in any of the tables of the FROM table list

      Here is the code in my qoq:

      <cfquery name="q_getCurrent" dbtype="query">
      Select myColumn
      From q_GetResults
      Where myColumn = 12
      </cfquery>

      Can anyone shed some light on what is occuring? Thanks.

      Mark F.