how to display checked checkboxes from comma separatedlist?

[MartinC]

I have a conference registration page that displays information from a database:
-Membership info comes from a members table.
-Conference info comes from a conferences table.
-Session info comes from a sessions table.

This page serves as both an 'add registration' page and an 'update
registration' page.

Visitors to this page select sessions they want to attend by checking a
checkbox. Via a registration action page, their selections end up as a comma
separated list (18, 12, 7, 2, 5, 9,) in the SID field of the registrants table.

How can I make their session selections appear as checked checkboxes on the
registration page when they visit this page as an update page?

This is the code I have for displaying the sessions list with checkboxes...
<table width="79%">
<tr align="left" valign="top">
<td width="7%"><strong>Session ID</strong></td>
<td width="38%"><strong>Title</strong></td>
<td width="17%"><strong>Fee</strong></td>
<td width="38%"><strong>Register by checking box </strong></td>
</tr>
<cfoutput query="getSessions">
<tr align="left" valign="top">
<td>#numberFormat(SID, '0000')#</td>
<td>#sessionTitle#</td>
<td><cfif sessionFee EQ 0>incl.<cfelse>#sessionFee#</cfif></td>
<td><input name="SID" type="checkbox" value="#getSessions.SID#" /></td>
</tr>
</cfoutput>
</table>

Thanks for any assistance that can be provided!

Cheers,


Martin

[Kronin555]

<input name="SID" type="checkbox" value="#getSessions.SID#"<cfif listfind(MySessionList,getSessions.SID) neq 0> checked</cfif>/>

[OldCFer]

Theres a couple of things:
1) You should not store values in a comma separated list. Each value should
be a new row in a table linked to the membership / conference combination.
2) If, as you say the SID is a comma separated field, can you do a
#numberFormat(SID, '0000')# on it?
3) Setting the checkbox to "#getSessions.SID#" means you've asigned it a
list value. Now the lists will further combine with other lists.

[Dixbert]

Anyone know how to do it in a format="flash" form with a cfinput type="checkbox" form control? Oh, and the checkbox is in a repeater driven by a query.