You can only use nested loops when specifying GROUPS within your Query.
Not sure what your final output is but you can use CFLOOP to loop through
your queries and only use one CFOUTPUT if needed.
----- Original Message -----
From: "Erika Foster" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 09, 2000 1:55 PM
Subject: Nesting <CFoutput>'s
> I need an input form driven from a loop - up to 52 inputs. One set of
inputs
> is a database driven select box, which needs to call a query to populate
the
> drop-down. I'm having trouble with Nesting the <CFOUTPUT>s. Here's the
> snippet of code that I'm trying to do:
>
>
> <cfloop index="i" from="1" to="52" step="1">
> <cfquery name="getdupes" datasource="personnel">
> SELECT *
> FROM planning_track
> WHERE week=#createodbcdate(startweek + ((7*(i-1))+ 1))# AND
> person=#person#
> </cfquery>
> <cfif getdupes.recordcount is 0>
> <TR>
> <td height="40">
> <cfoutput >
> Week of #dateformat(startweek + ((7*(i-1))+ 1))#:
>
> <input type="hidden" name="week#i#" value=#dateformat(startweek +
> ((7*(i-1))+ 1))#>
> </td>
> <TD><select name="task#i#">
> <option value="">
> <cfoutput>
> <option value="#gettasks.task#">#gettasks.task#
> </cfoutput>
> </select>
>
>
> </td>
>
> <TD><input type="text" name="task#i#"></td>
>
> </tr>
> </cfoutput>
> </cfif>
> </cfloop>
> <tr>
> <td colspan="2" align="right"><input type="submit"
> value="submit"></td>
>
> I'm getting this error:
>
> Invalid tag nesting configuration
>
> A query driven CFOUTPUT tag is nested inside a CFOUTPUT tag that also has
a
> QUERY= attribute. This is not allowed. Nesting these tags implies that you
> want to use grouped processing. However, only the top-level tag can
specify
> the query that drives the processing.
>
> I don't see any way around nesting these tags the way I have... I need to
> use both the loop and the query for the dropdown.
>
> What am I doing wrong?
>
> Thanks.
>
> Erika Foster
> engineering-environmental Management
> Applications Developer
> (505) 866-1654
> [EMAIL PROTECTED]
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
