<INPUT type="checkbox" name="RoleID" value="1"<CFIF ListContains(RoleID, 1)>
checked</CFIF>>
...
I am assuming you are storing the 'RoleID' value as a comma delimited list
in the database here.
----- Original Message -----
From: "sebastian palmigiani" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 20, 2000 1:47 PM
Subject: Query to Check Boxes --oops mistake [CF-Talk]
>
> OOPS...Made a mistake on the last post for the names of the default
> parameters.
>
> -------------------------
>
> I have 5 check boxes displayed in a form. I want to show a checked status
on
> the check boxes based on the query. The query output varies from 0 to 5
> records.
>
> Here is what I have now. There has to be a more efficient way.
>
> <cfparam name="checked1" default=" ">
> <cfparam name="checke2" default=" ">
> <cfparam name="checked3" default=" ">
> <cfparam name="checked4" default=" ">
> <cfparam name="checked5" default=" ">
>
> <cfoutput query="ShowPriviliges">
> <cfif RoleID EQ 1><cfset checked1 = "checked"></cfif>
> <cfif RoleID EQ 2><cfset checked2 = "checked"></cfif>
> <cfif RoleID EQ 3><cfset checked3 = "checked"></cfif>
> <cfif RoleID EQ 4><cfset checked4 = "checked"></cfif>
> <cfif RoleID EQ 5><cfset checked5 = "checked"></cfif>
> </cfoutput>
>
> <cfoutput>
> <tr>
> <td><input type="checkbox" name="RoleID" value="1" #checked1#></td>
> <td><input type="checkbox" name="RoleID" value="2" #checked2# ></td>
> <td><input type="checkbox" name="RoleID" value="3" #checked3#></td>
> <td><input type="checkbox" name="RoleID" value="4" #checked4#></td>
> <td><input type="checkbox" name="RoleID" value="5" #checked5#></td>
> </tr>
> </cfoutput>
>
> Sebastian
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> 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.mail-archive.com/[email protected]/
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.
