标题:[讨论]显示记录结果后有逗号
只看楼主
zln
Rank: 1
等 级:新手上路
帖 子:73
专家分:0
注 册:2006-1-6
 问题点数:0 回复次数:4 
[讨论]显示记录结果后有逗号
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>&nbsp;</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>&nbsp; </p>
<p>&nbsp; </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>


搜索更多相关主题的帖子: 逗号 血压 xueya input 
2006-03-01 16:26
蓝天白云
Rank: 1
等 级:新手上路
帖 子:114
专家分:0
注 册:2006-2-21
得分:0 
看不出你的代码有什么不对的,是不是你在添加的时候添上的呢,数据库的表里没有逗号吗?

2006-03-01 17:23
zln
Rank: 1
等 级:新手上路
帖 子:73
专家分:0
注 册:2006-1-6
得分:0 
数据库的表里只要是选择的单选中的任何一项("未查见异常"或"用户未检查该项"之一)都会有逗号,如果填写的是文本框("结果")就没有逗号了
2006-03-03 09:32
sorceress
Rank: 1
等 级:新手上路
帖 子:34
专家分:0
注 册:2006-3-2
得分:0 
你要用“,”来分隔不同的值,并且分隔之后要把“,”替换成空

我孤独的站在风中,等待着……
2006-03-03 09:49
zln
Rank: 1
等 级:新手上路
帖 子:73
专家分:0
注 册:2006-1-6
得分:0 
请问是用replace来替换吗?
2006-03-03 10:55



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-47829-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.233978 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved