Fejl i update query
Jeg får denne fejl:Error Type:
ADODB.Connection.1 (0x80004005)
SQLState: 4 Native Error Code: 1064 [TCX][MyODBC]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 't see the need to write what to members here. The reason for th
/totb/common/exec/edit_news.asp, line 7
Når jeg eksekverer denne kode:
strConnection ="DRIVER={MySql}; SERVER=XXXX; DATABASE=XXXX; UID=XXXX; PWD=XXXX"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open strConnection
strSQL = "UPDATE totb_news SET taster='" & Request.Form("taster") & "' WHERE id ='" & Request.Form("news_id") & "'"
Conn.execute(strSQL)
Conn.Close
Set Conn = Nothing
Response.Redirect("../../?section=")
Er der nogen af jer der kan hjælpe mig?
