Fejl MySQL Syntax
Hej!Jeg har en fejl i denne MySQL syntax, men jeg ved ikke, hvad der er galt.
Min kode ser sådan ud:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
strConn = "DRIVER={MySQL ODBC 3.51 Driver};"
strConn = strConn & "SERVER=mysql.fairhost.dk;"
strConn = strConn & "DATABASE=Znuggle;"
strConn = strConn & "UID=znuggle;"
strConn = strConn & "PWD=starlight;"
Conn.Open strConn
strSQL = "Update znuggle_user set ("
strSQL = strSQL & "Password= '" & Request("Password") & "', "
strSQL = strSQL & "Name1= '" & Request("Name") & "', "
strSQL = strSQL & "Email= '" & Request("Email") & "') "
strSQL = strSQL & "where ID = " & Request("ID")
Conn.Execute(strSQL)
Response.Redirect("index.asp?page=edit_general_info")
Conn.Close
Set Conn = Nothing
%>
Password, Name1 og Email er VARCHAR(255), hvor ID er INT(255).
Fejlmeddelelsen er:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(Password= 'test', Name1= 'test', Email= 'test
/znuggle_com/site/edit_general_info_do.asp, line 25
Jeg håber, der er nogen, der kan se, hvad der er galt.
