RE: looping (I think) problems

[Mike Connolly]

Query values can be lost when attempting to loop inside another.

Try storing the current query value of the parent loop into a variable
first.  Then use this inside your nested cfloop.

Try the following (See CURRENTCATID):

<cfquery name="getAllCats" datasource="#application.DSN#">
        SELECT CategoryID, Category
        FROM tblClientCategoryTypes
</cfquery>

<cfquery name="getCats" datasource="#application.DSN#">
        SELECT  ClientID, CategoryID
        FROM    tblClientCategory
        WHERE   ClientID=#FORM.ClientID#
</cfquery>

<form action="action.cfm" method="post">
<cfloop query="getAllCats">
        <cfoutput>#Category# </cfoutput>
        <CFSET CURRENTCATID = getAllCats.CategoryID>

        <cfloop index="CategoryID" list="getCats">
                <input type="checkbox" name="CategoryID" value="" 
                        <CFIF #CURRENTCATID# IS
#getCats.CategoryID#>checked</CFIF>
        </cfloop>
        <BR>
</cfloop>
</form>

-----Original Message-----
From: Seamus Campbell [mailto:[EMAIL PROTECTED]]
Sent: 11 July 2001 12:14
To: CF-Talk
Subject: looping (I think) problems


Hi

I have 3 tables:  (Access database)

tblClient  has fields:
ClientID
ClientEmail
ClientName
.....

tblClientCategory  has fields:
ClientID
CategoryID

tblClientCategoryTypes  has fields:
CategoryID
Category

So clientID can have one or more Categories.

I am trying to build an edit form so that on editing a single ClientID you 
see all categories (with checkboxes) in tblClientCategoryTypes  but have 
checked only those where there is a corresponding CategoryID in 
tblClientCategory .

I can only get my form to check the first corresponding record. This is my 
code (I'm sure that I need to cfloop in the form but am having huge
problems.

<cfquery name="getAllCats" datasource="#application.DSN#">
SELECT CategoryID, Category
FROM tblClientCategoryTypes
</cfquery>

<cfquery name="getCats" datasource="#application.DSN#">
SELECT  ClientID, CategoryID
FROM    tblClientCategory
WHERE   ClientID=#FORM.ClientID#
</cfquery>

<form action="action.cfm" method="post">
<cfloop query="getAllCats">
<cfoutput>#Category# </cfoutput><cfloop index="CategoryID" list="getCats">
<input type="checkbox" name="CategoryID" value="" <CFIF 
#getAllCats.CategoryID# IS #getCats.CategoryID#>checked</CFIF></cfloop>><BR>
</cfloop>
</form>

Any help gratefully received. I can understand conceptually how looping 
works but have have huge problems implementing anything that works.
MTIA
Seamus
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists