ok let me explain a bit more...
i have a system which shows what your friends have been doing
on my website...what artists they have added into the database
etc(Updates)....what i am trying to do is allow people to choose
which friends they would like to recieve updates for...
so i have a column called update_friend which is set to
default 1 in the friends table...then I have a query on the updates
page which shows the activity of all of your friends with a 1 in
the update_friend column...
to allow people to control which friends they recieve updates
from I have a form which checkboxes
<a href="
http://www.musicexplained.co.uk/delete/updates_opt.cfm">click</a>
if you want to remove a friend from your updates list you
would decheck the checkbox next to their name and then submit...
what i would then like to happen.....is for the query to
update the checked check boxes with 1 so the user will still
recieve updates from those people, and update the unchecked check
boxes with 0 so they no longer recieve updates from them
if I have 4 checked check boxes out of the 7 i am getting a
list (1,1,1,1) as an output, which would suggest initially that the
<cfparam name="FORM.update_friend" default="0"> isnt working,
but regardless of this I would like if john was checked, dave was
checked, mary was checked and james was checked, and then hilary,
donny and gas was unchecked.......john, dave, mary and james would
be updated with 1 in their update_friend columns, and the rest
would be updated with 0 ..
so essentially the query would be
UPDATE user_friend
SET update_friend = 1,1,1,1,0,0,0
WHERE id_friend IN (12,13,14,15,16,17,18)
thanks