I would suggest your database model is wrong.
If you have this situatiuon you need an association table that holds pair
values of regionid and someotherid.
This should make your data more useable as well.
Adam Reynolds
ColdFusion Consultant
HJ Heinz
Tel: 01344 397016 Fax: 01344 397010
Mobile: 07973 386620
Email: [EMAIL PROTECTED]
> ----------
> From: Andrew Scott[SMTP:[EMAIL PROTECTED]]
> Sent: 25 May 2000 01:50
> To: [EMAIL PROTECTED]
> Subject: RE: Processing multiple checkboxes?
>
> Whoops small fact I forgot to mention:-)
>
> -----Original Message-----
> From: Joseph Eugene [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 25 May 2000 10:45 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Processing multiple checkboxes?
>
>
> Give the Checkboxes the same "Name"
> if you set this in variable, you will see the different values that were
> checked in a Delimited String or List
> ----- Original Message -----
> From: "Andrew Scott" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, May 24, 2000 8:21 PM
> Subject: RE: Processing multiple checkboxes?
>
>
> > Check bozes come back as a comma seperated field, so if you select 2 it
> will
> > be selection1,selection2 then just throw this straight into the database
> as
> > is:-)
> >
> >
> > -----Original Message-----
> > From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, 25 May 2000 10:19 AM
> > To: Cf-Talk@Houseoffusion. Com
> > Subject: Processing multiple checkboxes?
> >
> >
> > Hi, All.
> >
> > I have several checkboxes in a form that represent regions. Multiple
> regions
> > can be selected, otherwise I would have used radio buttons.
> >
> > How can I take all values from each selected checkbox and dump them into
> one
> > database field so that I can take it out as a list later?
> >
> > TIA
> >
> > Cyrill
> >
> >
> >
> --------------------------------------------------------------------------
> --
> > --
> > Archives: http://www.eGroups.com/list/cf-talk
> > 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.eGroups.com/list/cf-talk
> > 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.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
> 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.
>
**********************************************************************
This email and any attachments are confidential and solely
for the use of the intended recipient. They may contain
material protected by legal professional or other privilege.
If you are not the intended recipient or the person responsible
for delivering to the intended recipient, you are not authorised
to and must not disclose, copy, distribute or retain this email
or its attachments. Although this email and its attachments
are believed to be free of any virus or other defect, it is the
responsibility of the recipient to ensure that they are virus free
and no responsibility is accepted by the company for any
loss or damage arising from receipt or use thereof.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
