He jon, how did you miss that easy punt last Sunday?
<g>
----- Original Message -----
From: "Jon Hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 20, 2000 9:13 PM
Subject: Re: Query to Check Boxes --oops mistake [CF-Talk]
> <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.
------------------------------------------------------------------------------
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.
