|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
November 14th, 2003, 12:57 AM
|
|||
|
|||
|
to update value of check box into a database
i am getting a prob. in database id is a autonumber .i want to update value after retriving the va,lue from database .that is going on i mean retriving valuue from database but not update.
below is code <%@ Language=VBScript %> <%Response.Buffer= true%> <!--#include file="connect.inc" --> <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> </HEAD> <BODY> <% dim icounter,ci set rs =server.CreateObject("adodb.recordset") rs.Open "select title,status from newsletter1 ",conn conn.execute "update newsletter1 set status='" & Request.Form("c1") & "' where id=" & Request.QueryString("value") & " " %> <form method="post" action="news1.asp?value"> <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="1"> <TBODY> <TR> <TD width="15%"><B>S No</B></TD> <TD width="35%"><B>Title</B></TD> <TD width="45%"><B>Select</B></TD></TR> <% iCounter =0 While Not rs.eof iCounter = iCounter+1 %> <TR> <TD valign="top" width="15%"><%=iCounter %></TD> <TD valign="top" width="15%"><%=rs("title")%></TD> <TD valign="top" width="15%"> <input type="checkbox" name="C1" value="ON" checked></TD> </TR> <% rs.movenext Wend %> <P> </P> <INPUT id=submit1 name=submit1 type=submit value=Submit> </form> </BODY> </HTML>
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > to update value of check box into a database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
