|
| |
|
|
Oztrades
Posts: 11
From: Vic, Australia
Status: offline
 |
Using Check boxes to do multiple deletes - 10/23/2001 20:37:00
I want to use checkboxes to multiple delete SOME results from a database (eg as in hotmail)
I have started by inserting a DRW into a form, adding checkboxes to the line and a delete button and posting to another form.
What value do i use in the checkbox, the form advanced properties...
So far i can only delete all the tests or receive an error requesting more parameters
Me thinks i need to add the IFTHEN comment but that means posting to another formmmmm
Regards ------------------
" TARGET=_blank>http://www.oztrades.com.au
your choice"
|
|
|
|
Spooky
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Using Check boxes to do multiple deletes - 10/23/2001 14:56:00
What youll do, is have a group of check boxes. Each with the same name.
eg "DeleteID"
Each checkbox needs to have a value = to the ID of the record.
When you perform a delete, you post to your delete page and do a :"...where ColumnID IN (::DeleteID::)"
What happens, is a comma delimited array is formed containing the ID numbers.
eg : 1,6,12,14
So your SQL string would actually look like :
"...where ColumnID IN (1,6,12,14)"
< Message edited by Spooky -- 10/28/2004 14:57:41 >
_____________________________
If you arent part of the solution, then there is good money to be made prolonging the problem
§þ k¥
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
