RE: [AspClassicAnyQuestionIsOk] Multiple records deletion

Thu, 27 Oct 2005 02:15:55 -0700 

sorry, In my code i have the field var1 to request.form("delfile") only, i have 
mistekenly posted that code, My code is
 
  <%
  
  Var1=request("delfile")
 SQL="delete from updown where ID IN ('"&Var1&"')"
 cn.execute SQL
 
  
 while not rs.eof
    a=rs(0) 
   
 %>
    
    <tr>
      <form name=frm method="post" action="recordsview.asp">
      <td width="10%" height="39" bgcolor="#B8B872" 
bordercolor="#B8B872">&nbsp;</td>
     
      <td width="10%" height="39" bgcolor="#808000" bordercolor="#B8B872">
      <font color="#FFFFFF">&nbsp;&nbsp;&nbsp;
      <input type="checkbox" name="delfile" value=<%=a%>></font></td>
     
      <td width="10%" height="39" bgcolor="#808000" bordercolor="#B8B872">
      <font color="#FFFFFF">&nbsp;<%=rs(0)%>&nbsp;</font></td>
        <input type=hidden name=hid1 value=<%=rs(0)%>>
      <td width="10%" height="39" bgcolor="#808000" bordercolor="#B8B872">
      <font color="#FFFFFF">&nbsp;<%=rs(1)%>&nbsp;</font></td>
      <td width="10%" height="39" bgcolor="#808000" bordercolor="#B8B872">
      <font color="#FFFFFF">&nbsp;<%=rs(2)%>&nbsp;</font></td>
      <td width="10%" height="39" bgcolor="#808000" bordercolor="#B8B872">
     
      <font color="#FFFFFF">&nbsp;<%=rs(3)%>&nbsp;</font></td>
      <td width="10%" height="39" bgcolor="#808000" bordercolor="#B8B872">
      <font color="#FFFFFF">&nbsp;<%=rs(4)%>&nbsp;</font></td>
      <td width="10%" height="39" bgcolor="#808000" bordercolor="#B8B872">
      <font color="#FFFFFF">&nbsp;<%=rs(6)%>&nbsp;</font></td>
      
      <td width="10%" height="39" bgcolor="#808000" bordercolor="#B8B872">
      <font face="Palatino Linotype" size="2" color="#FFFFFF">&nbsp;&nbsp;
      </font><font face="Palatino Linotype" size="2" 
color="#FFFFFF">&nbsp;</font></td>
      <td width="10%" height="39" bgcolor="#B8B872" 
bordercolor="#B8B872">&nbsp;</td>
      
          </tr>
              
        
         
  <%
    
          rs.movenext
          wend 
           %>

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>&nbsp;</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 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. 


---------------------------------



                
---------------------------------
 Enjoy this Diwali with Y! India Click here

[Non-text portions of this message have been removed]



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/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/

Reply via email to