Why my asp page error

tamgo · June 25th, 2003, 10:04 PM

conn.asp
<%
  Dim objConn
  Set objConn = Server.CreateObject("ADODB.Connection")
  objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
               "Data Source= D:\Inetpub\wwwroot\asp\22\222.mdb"
%>

input.asp
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body>
<FORM name=form action="sendmail.asp" method=post>
<TABLE class=v15 border=0>
  <TBODY>
    <TR>
      <TD class=v15 noWrap align=right>ÃÃÃÃ»Â£Âº</TD>
      <TD class=v15>
        <INPUT maxLength=40 name=name>
        </TD>
    </TR>
  </TBODY>
</TABLE>

<INPUT type=submit value=ÃÃ¡Â½Â» name="Send">

</FORM>
</body>
</html>

sendmail.asp

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body>
done!
<% dim rsusers
set rsusers = server.createobject("adodb.recordset")
rsusers.open "table"
rsusers("name") = request.form("name")
rsusers.update
%>
</body>
</html>

arp · June 30th, 2003, 03:32 AM

hi!!

I think you are not providing connection object to 'open' method of recordset in sendmail.asp

rsusers.open "table" should be

rsusers.open "table",objConn,1,2