急求大侠帮忙!小弟感激不尽!!!
下面这段代码是我从ACCESS表中读取出数据,然后显示在页面上,并在每一行留出一个多选框:
set conn=server.CreateObject("ADODB.Connection")
conn.open "DBQ="+server.mappath("..\meizhi.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
response.Write("<table width='100%' border='1' cellspacing='1' cellpadding='2'><strong>")
response.write("<tr>")
response.write("<td >")
response.Write("煤种代号")
response.write("</td>")
response.write("<td >")
response.Write("煤种名称")
response.write("</td>")
response.write("<td >")
response.Write("选择待配的煤种")
response.write("</td>")
response.Write("</tr>")
set rs=server.createobject("adodb.recordset")
sqltext="煤种"
rs.open sqltext,conn,3,2
if not rs.eof then
response.write("<tr>")
response.write("</td>")
response.write("<td width='40%' >")
response.Write(rs("ID"))
response.write("<td width='40%' >")
response.Write(rs("name"))
response.write("</td>")
response.Write("<td width='20%'>")
response.write("<input type='checkbox' name='fieldname' value='senddata' >")
response.write("</td>")
response.Write("</tr>")
rs.movenext
do while (not rs.eof)
response.write("<tr>")
response.write("</td>")
response.write("<td width='25%' >")
response.Write(rs("ID"))
response.write("<td width='25%' >")
response.Write(rs("name"))
response.write("</td>")
response.Write("<td width='20%'>")
response.write("<input type='checkbox' name='fieldname' value='senddata' >")
response.write("</td>")
response.Write("</div></tr>")
rs.movenext
loop
end if
set rs=nothing
我现在想把选中的那一行的ID号读出来,赋给两个变量,a和b,以便于后面的计算,如何实现??
恳请各路大侠赐教!!