[CFTALKTor] how to nest loop the database query?

[Mike Lau]

Hi list;       I was trying to nest loop 2 queries.  However, after the first round of the FIRST query (the SECOND query finished its first execution), it returns error said that the query FIRST is not available.  Anyone here can help me to solve this problem please?   ============================================================== Error Diagnostic Information Cannot set default query to FIRST A query by this name is not available at this time The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (11:2) to (11:24). Date/Time: 03/28/02 16:55:28 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; T312461) Remote Address: 207.255.255.182 ============================================================== here is the code:   <CFQUERY NAME="FIRST" DATASOURCE="#DSN#" USERNAME="#DB_USER#" PASSWORD="#DB_PASSWORD#">  SELECT DISTINCT Category  FROM RRC_members </CFQUERY> <CFLOOP QUERY="FIRST">      <CFQUERY NAME="SECOND" DATASOURCE="#DSN#" USERNAME="#DB_USER#" PASSWORD="#DB_PASSWORD#">       SELECT *       FROM RRC_members       WHERE category= '#FIRST.Category#'      </CFQUERY>      <CFOUTPUT QUERY="SECOND">                            <====================== line 11           #SECOND.member_id#<br>      </CFOUTPUT> </CFLOOP>     Rgds,   Mike