7 Replies Latest reply on Nov 8, 2009 3:02 PM by Jochem van Dieten

    QofQ Limitation?

    WestSide Level 1

      I have this master query that I want to run a sub-query on.  It works fine until I add a sub-select within my subquery..  This seems to be a limitation of how QofQ is built.  Are there any alternate solutions or does anyone have any insight.  I essentially want to do a sub-select in the query that I'm using against my master query.



      Psuedo code...


      <!--- Sub Query --->

      <cfquery name="result" dbtype="query">

        SELECTt col1, col2, (

                                       SELECT Count(*) FROM tblName

                                      ) as numWidgets

        FROM masterquery



      How can I achieve the net result, I'm fine doing it another way if can be  done

      Any help appreciated..