1. 论坛系统升级为Xenforo,欢迎大家测试!
    Dismiss Notice

asp的一个问题 很容易 可是我不懂 求解

Discussion in '后端开发' started by 小白, Nov 18, 2006.

  1. 小白

    小白 New Member

    Joined:
    Sep 25, 2005
    Messages:
    1,604
    Likes Received:
    9
    Code:
    <%
    Dim db,varyxnc,varyxjf,StrSql,newyxjf,xxyxjf,sql
    set db=Server.Createobject("ADODB.Connection") 
    db.Open "DBQ="&Server.Mappath("#cj.asp")&";DRIVER={Microsoft Access Driver (*.mdb)};" 
    varyxnc=Request("xyxnc")
    varyxjf=Request("xyxjf")
    sql="select yxjf from cj where yxnc='"&varyxnc&"'"
    xxyxjf=db.execute(sql)
    newyxjf=varyxnc+xxyxjf
    StrSql="UPDATE cj set yxjf='"&newyxjf&"' where yxnc='"&varyxnc&"'"
    db.execute(strSql)
    Response.Redirect "cj.asp"
    %>
    这个代码有问题 可以要怎么改才可以用啊?
     
  2. Ulysses

    Ulysses New Member

    Joined:
    Feb 5, 2006
    Messages:
    10,018
    Likes Received:
    16
    错误信息都不给……

    xxyxjf=db.execute(sql)

    貌似应该为

    xxyxjf=db.execute(sql)(0)
     
  3. Ulysses

    Ulysses New Member

    Joined:
    Feb 5, 2006
    Messages:
    10,018
    Likes Received:
    16
    好像可以合并为一条 SQL 语句……