If you set the name of all the check boxes to be the same, and the value of
each check box to be the unique identifier of the records you want to delete
from the database. The form will send the value of the all the boxes that
have been checked as a list of values - "1,34,86,100" for example, you can
then use this form vairable in a cfquery:
<cfquery . . . .>
delete from table_name where column_name in #form.check_box_name#
</cfquery>
Steve
-----Original Message-----
From: David Crowther [mailto:[EMAIL PROTECTED]]
Sent: 12 April 2000 10:34
To: '[EMAIL PROTECTED]'
Subject: Deleting Multiple Records?
<CF_newbie> I was just wondering if there was a way of deleting multiple
records at the same time?
In my admin section of a current project, I would like to provide the option
of selecting multiple records (by check box?) and then deleting all of the
selected records at one click of the submit button.
Is this possible, and if so, how do I do it?
Many thanks...
_____________________
d a v i d c r o w t h e r
w e b d e v e l o p e r
s i t d . c o m
t 0044 1753 865 731
f 0044 1753 865 785
----------------------------------------------------------------------------
--
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.
