radio button help

[anuva]

Hi,

I am new to asp and developing a quiz portal.

I need a help for this.

I am using MS Access database which is having a table called 'Quiz_Master' having fields such as 'Quiz_id', 'Quiz_Name', 'Quiz_Date','IsCurrent','Deleted'.

Here is my requirement:
1. I want a page where there will be radio buttons whose value will come from the above table showing all the list of 'Quiz_Name'.
2.The user will select one of the above quiz names and the 'IsCurrent' value for that particular quiz will be set to '1' in the database.

Please help me in this regard as soon as possible.

Thanks in advance

[shweta123]

Hi,

Here is the example code how you can do it,

<%
 
Dim con
Dim rs
Dim sql
 
con = Server.createObject("Adodb.Connection")
rs = Server.createObject("Adodb.Recordset")
 
con.connectionString ="..."
 
'Open connection
con.open
 
 
'Select data from your table
sql = "Select * from Quiz_Master"
set rs = con.Execute(sql)
 
 
'Fill the radioButtons with the values from the table
 
while not rs.Eof%>
 
<Input type ="radio" name ="radiobutton" value ="<%=rs.fields("Quiz_Name")">
 
<%rs.movenext
 
wend%>
 
 
Now , after submitting the page get the values of the radioButtons
 
<%
 
Dim x
 
For each x in Request.Form
 
 
   If x.name = ="radiobutton"  then
 
    'Update database
    sql ="Update Quiz_Master set isCurrent =1 where Quiz_Name ='" &  x & "' "
   end if
 
Next
 
%>

Hi,

I am new to asp and developing a quiz portal.

I need a help for this.

I am using MS Access database which is having a table called 'Quiz_Master' having fields such as 'Quiz_id', 'Quiz_Name', 'Quiz_Date','IsCurrent','Deleted'.

Here is my requirement:
1. I want a page where there will be radio buttons whose value will come from the above table showing all the list of 'Quiz_Name'.
2.The user will select one of the above quiz names and the 'IsCurrent' value for that particular quiz will be set to '1' in the database.

Please help me in this regard as soon as possible.

Thanks in advance