关于一段ASP代码 请大虾帮看看哪儿不对~~~~

来源:百度知道 编辑:UC知道 时间:2024/05/11 05:52:23
<%

dim rs
dim rs2
if m_status = 2 then
Set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = MM_constr_STRING
rs.Source = "SELECT * FROM order_info WHERE order_id = '"+m_orderid+"'"
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 1
rs.Open()

Set rs2 = Server.CreateObject("ADODB.Recordset")
rs2.ActiveConnection = MM_constr_STRING
rs2.Source = "SELECT * FROM cardNoInfo WHERE state=false and card_id = '"+getOrderInfo_rs("card_id")+"'"
rs2.CursorType = 0
rs2.CursorLocation = 2
rs2.LockType = 1
rs2.Open()
%>
<%
dim i
for i=1 to rs2("card_num")

<tr>
<td width="140" bgcolor="#FFFFFF"><div align="right">卡 号</div></td>
<td width="437" bgco

不知道

Set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = MM_constr_STRING
rs.Source = "SELECT * FROM order_info WHERE order_id = '"+m_orderid+"'"
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 1
rs.Open()

以上程序太罗嗦了这样写好点:
Set rs = Server.CreateObject("ADODB.Recordset")
mysql = "SELECT * FROM order_info WHERE order_id = '" & m_orderid & "'"
rs.Open MM_constr_STRING,mysql,1,2

你的数据库中 ID 是不是全不都是字符类型,我看你的所有 ID 都加了"'",你自己检查一下数据库和sql语句中的类型是否一致!