×

Loading...
Ad by
Ad by

@Calgary

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

  • 老程序员第一次用copilot的一点点体会
  • 现在社区游泳池招救生员巡逻，过一会还要不停的点人头，这工作是否很快就被AI代替了，装一个摄像头后面是AI处理系统，这样只招一个等着救人就行了，人头沉下水一定时间立马强光照射，还可以分析水下人的状况来判断是否溺水等
  • 新冠疫苗引发心肌炎? 最新研究这样看
  • 这道几何题有解吗?
  • SAM 2 Demo
    • 枫下论坛主坛 /  工作学习 /  专业技术讨论