saseow
Posts: 744
|
| Posted: 10/06/2008, 8:49 AM |
|
I have an editable grid with the users data: I want to get the user_id from the row that is to be deleted. I will use this to delete data in other tables with this users id. Any pointers?
Also, I presume that this will only work when a single user is selected for deletion. Is there any way to allow only single Delete Checkboxes to be selected?
Trevor
|
 |
 |
saseow
Posts: 744
|
| Posted: 10/07/2008, 12:42 AM |
|
In case anyone else has a similar hassle. I suggest using contraints as it is by far the most simple solution to implement
I have tried:
CCS: Had problems getting the user_id from the deleted record.
Triggers: Only one delete allowed in a delete event. I used OLD.ID and it worked for a single table.
Finally I settled on MySQL constraints and it all works fine.
Trevor
|
|
|
|
|
