I thought you would be getting just a single member_id by reading this. But in the code that you posted, you don't seem to be doing anything with DELETE as it the page is named delete.asp
Also seeing the code posted in your last post, if your member_id all stored in value attribute of checkboxes listed there, I would suggest you name all those checkboxes with same name, and request("member_id")[hope that is all your checkboxes are named as member_id] which on submission, would yield you all those values in a string seperated by comma, which can directly be used within IN() clause of the select statement, and you don't have to loop through to construct that.
Is that you are trying to select the rows based on member_Id on that page? May be I am lost.
But if you are already on track, then I would better not try and confuse youwith mine.
All the best.
Cheers!
_________________________
- Vijay G
Strive for Perfection
|