×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

@Florida

AsP & Access insert into or update can't be exceuted help please

jenny1(mouse)
本文发表在 rolia.net 枫下论坛<% name=request("text1")
card_ID=request("text2")
set rs=server.createobject("adodb.recordset")
set rs1=server.createobject("adodb.recordset")
sql="select * from employee where name='"&name&"'"
rs.Open sql,conn,1,1
if rs.EOF or rs.bof then
sql="insert into employee(name,card_ID,mobile,address,backup) values('"&name&"','"&card_ID&"','"&mobile&"','"&address&"','"&backup&"')"
rs1.Open sql,conn,1,3
conn.execute sql

response.write "<script language=JavaScript>" & chr(13) & "alert('&Iacute;&not;already exist');"&"window.location.href = 'index.asp'"&" </script>"
set rs1=nothing
else
response.write "<script language=JavaScript>" & chr(13) & "alert('&acute;add succes');" & "history.back()" & "</script>"
end if
rs.Close
set rs=nothing
%>
I use
set conn=server.createobject("ADODB.connection)
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/emplyee.mdb"
set rs=server.createobject("adodb.recordset") as instead of above
prompt error, need a queryable statement.
I don't know what's wrong , please give me some tips
thank you so much更多精彩文章及讨论，请光临枫下论坛 rolia.net
(#2424460@0)
Last Updated: 2005-7-29
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / 专业技术讨论 / AsP & Access insert into or update can't be exceuted help please -jenny1(mouse); 2005-7-29 {1147} (#2424460@0)
    本文发表在 rolia.net 枫下论坛<% name=request("text1")
    card_ID=request("text2")
    set rs=server.createobject("adodb.recordset")
    set rs1=server.createobject("adodb.recordset")
    sql="select * from employee where name='"&name&"'"
    rs.Open sql,conn,1,1
    if rs.EOF or rs.bof then
    sql="insert into employee(name,card_ID,mobile,address,backup) values('"&name&"','"&card_ID&"','"&mobile&"','"&address&"','"&backup&"')"
    rs1.Open sql,conn,1,3
    conn.execute sql

    response.write "<script language=JavaScript>" & chr(13) & "alert('&Iacute;&not;already exist');"&"window.location.href = 'index.asp'"&" </script>"
    set rs1=nothing
    else
    response.write "<script language=JavaScript>" & chr(13) & "alert('&acute;add succes');" & "history.back()" & "</script>"
    end if
    rs.Close
    set rs=nothing
    %>
    I use
    set conn=server.createobject("ADODB.connection)
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open "c:/webdata/emplyee.mdb"
    set rs=server.createobject("adodb.recordset") as instead of above
    prompt error, need a queryable statement.
    I don't know what's wrong , please give me some tips
    thank you so much更多精彩文章及讨论，请光临枫下论坛 rolia.net
    • if name and card_id are user defined variables, you do not need to put quotation marks around them. i guess. try test your sql query within access. -23456789(大白呼); 2005-7-29 (#2424533@0)
    • delete rs1.Open sql,conn,1,3 -cockle(cockle); 2005-7-29 (#2424591@0)

More Topics

  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
  • 扔硬币的实验研究
    • 枫下论坛主坛 /  工作学习 /  专业技术讨论