注册 登录
编程论坛 ASP技术论坛

紧求读取数据问题???通宵没有解决

gao5411 发布于 2008-05-14 07:02, 458 次点击
查询系统工能,查看订单一个orderInfo.asp

<%
            dim rsObj,strSQL
            dim orderID
            orderID = RealString(Request.QueryString("orderID"))
            set rsObj = Server.CreateObject("ADODB.RecordSet")
        if orderID = "" then orderID = 0
        
                strSQL = "SELECT * FROM OrderList WHERE id = "& orderID &" AND memberID = '"&Session                          ("memberID")&"'"
                rsObj.Open strSQL, conn, adOpenKeyset, adLockReadOnly
        
%>


求大师出手帮下

[[it] 本帖最后由 gao5411 于 2008-5-14 07:04 编辑 [/it]]
5 回复
#2
gao54112008-05-14 07:03
急着用
#3
gao54112008-05-14 07:36
前页面接入
<form method = "post" name = "orderSearch" action = "orderSearch.asp" ID = "Form1">
            <td width = "45%" valign = "top"> 订单号
              <input type = "text" size = "12" name = "orderID"  onKeyUp="" = "checknum(orderSearch.orderID)" style = "font-size: 9pt; border: 1px solid #7D85A2; background-color: rgb(210,232,255)" id = "Text1" />
              <%    <!-- #include file = "orderInfo.asp"-->  %>
            <input type = "submit" name = "Submit3" value = "订单搜索" class = "forInput" style = "font-size: 9pt; border: 1px solid #7D85A2; background-color: rgb(210,232,255)" id = "Submit1" /></td>
          </form>
#4
xxzdm2008-05-14 11:13
汗..大哥..你用啥取值哦..你提交查询的时候..有不会在地址栏提取ID值..不是用..orderID = RealString(Request.QueryString("orderID"))..应该是orderID = RealString(Request.Form("orderID")) ..取值....还不行的话+我Q:397523123...

[[it] 本帖最后由 xxzdm 于 2008-5-14 11:21 编辑 [/it]]
#5
gao54112008-05-14 11:51
太感谢,
#6
gao54112008-05-14 11:53
我基本功力不够,
1