If the checkboxes have the same name it will pass them through the form object as a comma delimited string. Response.Write your SQL statement out and check that that's what's happening, and if not, post your code. Dan
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jegatha Sent: 27 October 2005 06:40 To: [email protected] Subject: Re: [AspClassicAnyQuestionIsOk] Multiple records deletion hai, Thanks for your valid suggestion, i trid with that this works for a single record only, not work with multiple records. i have more than 30 checkboxes with same name,is there any problem with this. Thanks Jegatha Michael Brinkley <[EMAIL PROTECTED]> wrote: ' For numbers: DELETE FROM MyTable WHERE Field IN ("& request.form("CheckBoxField") &") However if the checkbox values are text then you'll need to massage the selected items first: ' remove spaces Var = replace(request.form("CheckBoxField")," ","") ' add the apostophes Var = replace(Var,",","',"") DELETE FROM MyTable WHERE Field IN ('"& Var &"') Ryan Olshan <[EMAIL PROTECTED]> wrote:Why not use a foreach loop to loop through all the checked items and then delete each item that is checked? /Ryan On 10/26/05, Jegatha <[EMAIL PROTECTED]> wrote: > > > > hai all, > > I need to do multiple records deletion using check box. I trried with form > collection variable and item count in form(request.form.count),not yet > getting. > > have any idea plz let me know. > > thanks in adv. > > > regards, > jegatha > > > --------------------------------- > Yahoo! India Matrimony: Find your partner now. > > [Non-text portions of this message have been removed] > > > > SPONSORED LINKS > Basic programming language<http://groups.yahoo.com/gads?t=ms&k=Basic+programming+language&; w1=Basic+programming+language&w2=Computer+programming+languages&w3=Progr amming+languages&w4=Java+programming+language&c=4&s=126&.sig=bnac3LCZptt b3c9FvbVU-A> Computer > programming languages<http://groups.yahoo.com/gads?t=ms&k=Computer+programming+langu ages&w1=Basic+programming+language&w2=Computer+programming+languages&w3= Programming+languages&w4=Java+programming+language&c=4&s=126&.sig=1Czd2h KCO9_u4KVZQperFQ> Programming > languages<http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=B asic+programming+language&w2=Computer+programming+languages&w3=Programmi ng+languages&w4=Java+programming+language&c=4&s=126&.sig=TyHGCjod4YOKITr Sq1xccQ> Java > programming language<http://groups.yahoo.com/gads?t=ms&k=Java+programming+language&w 1=Basic+programming+language&w2=Computer+programming+languages&w3=Progra mming+languages&w4=Java+programming+language&c=4&s=126&.sig=PZAexF9LyXpK b3HDJSlB1g> > ------------------------------ > YAHOO! GROUPS LINKS > > > - Visit your group "AspClassicAnyQuestionIsOk<http://groups.yahoo.com/group/AspClassicAnyQu estionIsOk>" > on the web. > - To unsubscribe from this group, send an email to: > [EMAIL PROTECTED]<AspClassicAnyQuest [EMAIL PROTECTED]> > - Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > > ------------------------------ > -- Thank you, Ryan Olshan <asp:Web Programmer, Owner /> TeraNet Systems http://www.teranetsystems.com --------Internet E-Mail Confidentiality Statement-------- The content of and attachment(s) to this electronic transmission contains information from TeraNet Systems and is intended for the use of the person, firm or entity to which it is directed herein, and may contain information that is private, confidential, exempt from disclosure under applicable law, and/or proprietary to TeraNet Systems and is protected by law. If you are not the intended recipient, or the employee or agent responsible for delivering this message to the intended recipient, any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this message in error, please notify the sender, [EMAIL PROTECTED], immediately by reply e-mail and delete the original message and any attachment(s) without reading or saving in any matter. Thank you for your cooperation. [Non-text portions of this message have been removed] SPONSORED LINKS Basic programming language Computer programming languages Programming languages Java programming language --------------------------------- YAHOO! GROUPS LINKS Visit your group "AspClassicAnyQuestionIsOk" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- [Non-text portions of this message have been removed] SPONSORED LINKS Basic programming language Computer programming languages Programming languages Java programming language --------------------------------- YAHOO! GROUPS LINKS Visit your group "AspClassicAnyQuestionIsOk" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Yahoo! India Matrimony: Find your partner now. [Non-text portions of this message have been removed] ________________________________ YAHOO! GROUPS LINKS * Visit your group "AspClassicAnyQuestionIsOk <http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] subscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . ________________________________ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
