With the check box fields, make sure the value is set to 1.
Then when adding the record, you need to do a CFIF test to see if the
checkbox is checked...
INSERT INTO YourTable (accessArray)
VALUES ('<CFIF IsDefined("Checkbox1")>1<CFELSE>0</CFIF>|<CFIF
IsDefined("Checkbox2")>1<CFELSE>0</CFIF>|<CFIF
IsDefined("Checkbox3")>1<CFELSE>0</CFIF>')
Etc etc. Alternately, you may want to name the fields Access_1, Access_2
etc, and then loop over them.
Hope this helps a little
Nick
on 16/7/01 1:47 PM, Melly Masram at [EMAIL PROTECTED] wrote:
> Guys..i have a problem to insert values 1 and 0 into a
> database. I want the insert values to be like below:-
>
>
> 1|0|1|1|0 ->this value will be insert to a field
> name AccessArray. The value 1 and 0 depends on the
> user choice when he/she tick the checkbox value.
>
> Could you guys help me,as soon as possible!
> Thanz
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
