Back to my original suggestion.
Use a foreach loop to iterate through all the checked items and then delete
those that are checked.
/Ryan
On 10/27/05, Dan Powderhill <[EMAIL PROTECTED]> wrote:
>
> hid1 is the name of the hidden field you have in your HTML, not the
> checkbox - shouldn't you be setting the value of Var1 to
> request.form("delfile")?
>
> Also you appear to be missing a closing angle-bracket on your checkbox
> tag.
>
> Dan
>
> ________________________________
>
> From: [email protected]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jegatha
> Sent: 27 October 2005 09:41
> To: [email protected]
> Subject: RE: [AspClassicAnyQuestionIsOk] Multiple records deletion
>
>
> Thank u Dan,
>
> ya it written all the check box values(including not selected) with
> comma.
>
> i have post this page to the same page is there any problem with that ?
>
> this is my code:
>
>
>
> <%
> Var1=request("hid1")
> SQL="delete from updown where ID IN ('"&Var1&"')"
> cn.execute SQL
> response.write Var1
>
> while not rs.eof
> a=rs(0)
>
> %>
>
>
> <tr>
> <form name=frm method="post" action="recordsview.asp">
> <td> </td>
>
> <td><input type="checkbox" name="delfile" value=<%=a%></td>
>
>
> <td><%=rs(0)%></td>
>
>
> <input type=hidden name=hid1 value=<%=rs(0)%>>
> <td><%=rs(1)%></td>
> <td><%=rs(2)%></td>
> <td><%=rs(3)%></td>
> <td><%=rs(4)%></td>
> <td><%=rs(6)%></td>
> </tr>
> <%
> rs.movenext
> wend
> %>
>
> Thanks
>
> jegatha
>
>
>
>
> ---------------------------------
> Enjoy this Diwali with Y! India Click here
>
> [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]
>
>
>
> 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=Programming+languages&w4=Java+programming+language&c=4&s=126&.sig=bnac3LCZpttb3c9FvbVU-A>
> Computer
> programming
> languages<http://groups.yahoo.com/gads?t=ms&k=Computer+programming+languages&w1=Basic+programming+language&w2=Computer+programming+languages&w3=Programming+languages&w4=Java+programming+language&c=4&s=126&.sig=1Czd2hKCO9_u4KVZQperFQ>
> Programming
> languages<http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Basic+programming+language&w2=Computer+programming+languages&w3=Programming+languages&w4=Java+programming+language&c=4&s=126&.sig=TyHGCjod4YOKITrSq1xccQ>
> Java
> programming
> language<http://groups.yahoo.com/gads?t=ms&k=Java+programming+language&w1=Basic+programming+language&w2=Computer+programming+languages&w3=Programming+languages&w4=Java+programming+language&c=4&s=126&.sig=PZAexF9LyXpKb3HDJSlB1g>
> ------------------------------
> 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]<[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]
------------------------ 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/
