 |
|
เออเร่อว่า Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/TRAIMIT05/Insert2.asp, line 72 ( Conn.Execute mySql, ,adCmdText อันแรก)
strConn= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("DB/TRAIMIT05.mdb")
Set Conn=Server.CreateObject("Adodb.Connection")
Set rs=Server.CreateObject("Adodb.Recordset")
Conn.Open strConn
mySql="INSERT INTO TRegister05 (SNAME,USERNAME,"&",LASTNAME,GENDER,EMAIL,ADDRESS) VALUES('" &Sname&_
"',"& Username& ",'"&Lname&"','" &Gender&"','"&Email&"','"&Address&"')"
Conn.Execute mySql, ,adCmdText
rs.Open "TRegister05",Conn,adOpenStatic
rs.MoveLast
ID=rs.Fields("USERNAME")
rs.Close
Set rs=Nothing
mySql="UPDATE TLogin05 SET USERNAME="&USERNAME&",' PASSWORD="&Pass&",CONFIRMPASS='"&Rpass&_
"WHERE USERNAME ="&Session.SessionUSERNAME
Conn.Execute mySql, ,adCmdText
Conn.Close
Set Conn=Nothing
Response.write"ºบันทึกข้อมูลเรียบร้อย"
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
7 ต.ค. 2549 09:45:58 |
By :
yoyonok |
View :
1973 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
Load balance : Server 00
