[讨论]显示记录结果后有逗号
regist1.asp代码:<tr bgcolor="#FFFFFF">
<td height="109" align="right">血压：</td>
<td height="109"><p>未查见异常
<input type="radio" name="xueya" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="xueya" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="xueya" id="xueya" maxlength="300">
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">心：</td>
<td height="109"><p> </p>
<p>未查见异常
<input type="radio" name="xin" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="xin" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="xin" id="xin" maxlength="300">
</p>
<p> </p>
<p> </p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">肺：</td>
<td height="109"><p>未查见异常
<input type="radio" name="fei" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="fei" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="fei" id="fei" maxlength="300">
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">肝脾：</td>
<td height="109"><p>未查见异常
<input type="radio" name="ganpi" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="ganpi" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="ganpi" id="ganpi" maxlength="300">
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">五官：</td>
<td height="109"><p>未查见异常
<input type="radio" name="wuguan" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="wuguan" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="wuguan" id="wuguan" maxlength="300" >
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">眼底：</td>
<td height="109"><p>未查见异常
<input type="radio" name="yandi" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="yandi" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="yandi" id="yandi" maxlength="300">
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">外科：</td>
<td height="109"><p>未查见异常
<input type="radio" name="waike" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="waike" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="waike" id="waike" maxlength="300" >
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">心电图：</td>
<td height="109"><p>未查见异常
<input type="radio" name="xindiantu" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="xindiantu" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="xindiantu" id="xindiantu" maxlength="300">
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">B超：</td>
<td height="109"><p>未查见异常
<input type="radio" name="bchao" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="bchao" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="bchao" id="bchao" maxlength="300">
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">X光：</td>
<td height="109"><p>未查见异常
<input type="radio" name="xguang" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="xguang" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="xguang" id="xguang" maxlength="300" >
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">肝功：</td>
<td height="109"><p>未查见异常
<input type="radio" name="gangong" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="gangong" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="gangong" id="gangong" maxlength="300">
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">乙肝表抗：</td>
<td height="109"><p>阴性
<input type="radio" name="yiganbiaokang" value="阴性">
</p>
<p>用户未检查该项
<input type="radio" name="yiganbiaokang" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="yiganbiaokang" id="yiganbiaokang" maxlength="300" >
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">胆固醇：</td>
<td height="109"><p>未查见异常
<input type="radio" name="danguchun" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="danguchun" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="danguchun" id="danguchun" maxlength="300" >
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">甘油三脂：</td>
<td height="109"><p>未查见异常
<input type="radio" name="ganyousanzhi" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="ganyousanzhi" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="ganyousanzhi" id="ganyousanzhi" maxlength="300" >
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">血糖：</td>
<td height="109"><p>未查见异常
<input type="radio" name="xuetang" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="xuetang" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="xuetang" id="xuetang" maxlength="300">
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">血尿酸：</td>
<td height="109"><p>未查见异常
<input type="radio" name="xueniaosuan" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="xueniaosuan" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="xueniaosuan" id="xueniaosuan" maxlength="300">
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">尿素氯：</td>
<td height="109"><p>未查见异常
<input type="radio" name="niaosulu" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="niaosulu" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="niaosulu" id="niaosulu" maxlength="300" >
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">肌酐：</td>
<td height="109"><p>未查见异常
<input type="radio" name="jigan" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="jigan" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="jigan" id="jigan" maxlength="300" >
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">血常规：</td>
<td height="109"><p>未查见异常
<input type="radio" name="xueyachanggui" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="xueyachanggui" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="xueyachanggui" id="xueyachanggui" maxlength="300" >
</p></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="109" align="right">尿常规：</td>
<td height="109"><p>未查见异常
<input type="radio" name="niaochanggui" value="未查见异常">
</p>
<p>用户未检查该项
<input type="radio" name="niaochanggui" value="用户未检查该项">
</p>
<p>检查结果:
<input type="text" name="niaochanggui" id="niaochanggui" maxlength="300" >
</p></td>
</tr>
addnewuser1.asp代码
xueya = Request.Form("xueya")
xin= Request.Form("xin")
fei= Request.Form("fei")
ganpi= Request.Form("ganpi")
wuguan= Request.Form("wuguan")
yandi= Request.Form("yandi")
waike= Request.Form("waike")
xindiantu= Request.Form("xindiantu")
bchao= Request.Form("bchao")
xguang= Request.Form("xguang")
gangong= Request.Form("gangong")
yiganbiaokang=request.form("yiganbiaokang")
danguchun= Request.Form("danguchun")
ganyousanzhi= Request.Form("ganyousanzhi")
xuetang= Request.Form("xuetang")
xueniaosuan= Request.Form("xueniaosuan")
niaosulu= Request.Form("niaosulu")
jigan= Request.Form("jigan")
xueyachanggui= Request.Form("xueyachanggui")
niaochanggui= Request.Form("niaochanggui")
set rs=server.CreateObject("adodb.recordset")
sqlstr="select * from tijianjilu where Tijiandanhao is null"
rs.open sqlstr,conn,1,3
rs.addnew
rs("xueya")=xueya
rs("xin")=xin
rs("fei")=fei
rs("ganpi")=ganpi
rs("wuguan")=wuguan
rs("yandi")=yandi
rs("waike")=waike
rs("xindiantu")=xindiantu
rs("bchao")=bchao
rs("xguang")=xguang
rs("gangong")=gangong
rs("yiganbiaokang")=yiganbiaokang
rs("danguchun")=danguchun
rs("ganyousanzhi")=ganyousanzhi
rs("xuetang")=xuetang
rs("xueniaosuan")=xueniaosuan
rs("niaosulu")=niaosulu
rs("jigan")=jigan
rs("xueyachanggui")=xueyachanggui
rs("niaochanggui")=niaochanggui
rs.update
rs.close
set rs = nothing
conn.close
set conn=nothing
response.Redirect("regSuccessful.asp")
'end if
%>
viewrecord.asp代码:
<td width="54" height="20" align="center">血压</td>
<td width="163" height="20" align="center">心</td>
<td width="224" height="20" align="center">肺</td>
<td width="224" height="20" align="center">肝脾</td>
<td width="224" height="20" align="center">五官</td>
<td width="224" height="20" align="center">眼底</td>
<td width="224" height="20" align="center">外科</td>
<td width="224" height="20" align="center">心电图</td>
<td width="224" height="20" align="center">B超</td>
<td width="224" height="20" align="center">X光</td>
<td width="55" height="20" align="center">肝功</td>
<td width="55" height="20" align="center">乙肝表抗</td>
<td width="55" height="20" align="center">胆因醇</td>
<td width="55" height="20" align="center">甘油三脂</td>
<td width="55" height="20" align="center">血糖</td>
<td width="55" height="20" align="center">血尿酸</td>
<td width="55" height="20" align="center">尿素氯</td>
<td width="55" height="20" align="center">肌酐</td>
<td width="55" height="20" align="center">血压常规</td>
<td width="55" height="20" align="center">尿常规</td>
</tr>
<%do while not rs.eof%>
<tr>
<td width="54" height="20" align="center"><%=rs("xueya")%></td>
<td width="163" height="20" align="center"><%=rs("xin")%></td>
<td width="224" height="20" align="center"><%=rs("fei")%></td>
<td width="224" height="20" align="center"><%=rs("ganpi")%></td>
<td width="224" height="20" align="center"><%=rs("wuguan")%></td>
<td width="224" height="20" align="center"><%=rs("yandi")%></td>
<td width="224" height="20" align="center"><%=rs("waike")%></td>
<td width="224" height="20" align="center"><%=rs("xindiantu")%></td>
<td width="224" height="20" align="center"><%=rs("bchao")%></td>
<td width="224" height="20" align="center"><%=rs("xguang")%></td>
<td width="55" height="20" align="center"><%=rs("gangong")%></td>
<td width="55" height="20" align="center"><%=rs("yiganbiaokang")%></td>
<td width="55" height="20" align="center"><%=rs("danguchun")%></td>
<td width="55" height="20" align="center"><%=rs("ganyousanzhi")%></td>
<td width="55" height="20" align="center"><%=rs("xuetang")%></td>
<td width="55" height="20" align="center"><%=rs("xueniaosuan")%></td>
<td width="55" height="20" align="center"><%=rs("niaosulu")%></td>
<td width="55" height="20" align="center"><%=rs("jigan")%></td>
<td width="55" height="20" align="center"><%=rs("xueyachanggui")%></td>
<td width="55" height="20" align="center"><%=rs("niaochanggui")%></td>
