我修改的一个程序,做的是一个购物车,选购产品填写数量之后有个单位选项,原来只有箱和瓶(value=0和1)对应后台数据表orderlist的price是0和1。现在我增加了一个单位套(value=2),发现后台数据表的price就变成1000了。怎么回事???
程序如下:
<%
set rs=server.createobject("adodb.recordset")
sql="select * from product where id in ("&session("products")&")"
rs.open sql,conn,1,1
on error resume next
i=0
arraynum=split(Session("counts"),",")
do while not rs.eof
%>
<tr align="center" >
<td height="27" valign="middle"><%=rs("Name")%></td>
<td valign="middle"><%=rs("PType")%></td>
<td valign="middle" style="display:none">¥<input type="text" name="price" size="10" style=" border-bottom:1px; border-right:1px; border-left:0px; border-top:0px" readonly value="<%=rs("price1")%>"></td>
<!-- <%if session("counts")="" then response.Write("1") else response.Write(arraynum(i+2)) end if%>-->
<td valign="middle"><input type="text" name="number" size="5" value="1" onBlur="shop(<%=i%>);ly();" onKeyUp="this.value=this.value.replace(/\D/g,'')" onbeforrepaste="this.value=this.value.replace(/\D/g,'')"><input type="hidden" value="document.formshop.number.value" name="num"></td>
<td valign="middle" >
<select name="result">
<option value=0>箱</option>
<option value=1>瓶</option>
<option value=2>套</option>
</select></td>
<td valign="top"><a href="buy.asp?Proid=<%=rs("id")%>&action=del">删除</a></td>
</tr>
<%
i=i+1
rs.movenext
loop
rs.close
set rs=nothing
end if
%>
程序如下:
<%
set rs=server.createobject("adodb.recordset")
sql="select * from product where id in ("&session("products")&")"
rs.open sql,conn,1,1
on error resume next
i=0
arraynum=split(Session("counts"),",")
do while not rs.eof
%>
<tr align="center" >
<td height="27" valign="middle"><%=rs("Name")%></td>
<td valign="middle"><%=rs("PType")%></td>
<td valign="middle" style="display:none">¥<input type="text" name="price" size="10" style=" border-bottom:1px; border-right:1px; border-left:0px; border-top:0px" readonly value="<%=rs("price1")%>"></td>
<!-- <%if session("counts")="" then response.Write("1") else response.Write(arraynum(i+2)) end if%>-->
<td valign="middle"><input type="text" name="number" size="5" value="1" onBlur="shop(<%=i%>);ly();" onKeyUp="this.value=this.value.replace(/\D/g,'')" onbeforrepaste="this.value=this.value.replace(/\D/g,'')"><input type="hidden" value="document.formshop.number.value" name="num"></td>
<td valign="middle" >
<select name="result">
<option value=0>箱</option>
<option value=1>瓶</option>
<option value=2>套</option>
</select></td>
<td valign="top"><a href="buy.asp?Proid=<%=rs("id")%>&action=del">删除</a></td>
</tr>
<%
i=i+1
rs.movenext
loop
rs.close
set rs=nothing
end if
%>
