I AM DESIGNING A PAGE FOR MY WEB SITE UNDER CONSTRUCTION.
I HAVE A DATABASE FILE CALLED "PASS.MDB" AT SERVER ROOT URL: \DB\PASS.MDB
MY PASS.DB FILE CONTAINS A TABLE CALLER 'pass' which contains "ID,CALLER,PW,AGE,REMARK" FIELDS IN IT WITH DATA FILLED.
WHEN I TRY TO TEST FOLLOWING SQL STATEMENTS 'SELECT', IT WORKED WELL. AND GOT THE RESULT.
BUT WHEN I TRY TO WORK WITH SQL STATEMENT 'INSER INTO' IT SHOWS ERROR MASSAGE.
AS I AM NOT WELL VERSED WITH DATABASE, PLEASE EXPLAIN WHERE THE MISTAKE HAPPENED AND ALSO THE CORRECT CODE THAT I HAVE TO USE.
THE ASP PAGE WITH SELECT STATEMENT THAT WORKED WELL:
<html>
<body>
<%
dim conn,DSN,rs,sql
Set conn = Server.CreateObject("adodb.connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.Mappath("\db\pass.mdb")
conn.Open DSN
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT * FROM pass"
rs.Open sql, conn
%>
<table border="1" width="100%">
<tr>
<%for each x in rs.Fields
response.write("<th>" & x.name & "</th>")
next%>
</tr>
<%do until rs.EOF%>
<tr>
<%for each x in rs.Fields%>
<td><%Response.Write(x.value)%></td>
<%next
rs.MoveNext%>
</tr>
<%loop
rs.close
conn.close
%>
</table>
</body>
</html>
------------------------------------------------------------------
THE asp page with INSERT STATEMENT THAT SHOWED ERROR:
-----------------------------------------------------------------
<html>
<body>
<%
dim conn,DSN,rs,sql
Set conn = Server.CreateObject("adodb.connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.Mappath("\db\pass.mdb")
conn.Open DSN
set rs = Server.CreateObject("ADODB.recordset")
sql="INSERT INTO pass(CALLER,PW,REMARK) VALUE('BABY','AsDgF','WHITE')"
rs.Open sql, conn
rs.close
conn.close
%>
</body>
</html>
Aucun commentaire:
Enregistrer un commentaire