sql statement & request.form

[emartel]

Hi,
Im trying to edit database records via my website. I have the code done except that one line keeps bringing up errors. The MYSQL statement has incorrect syntax and I cant get it right. Id really appreciate help!!
Many thanks inn advance:

<% 
Dim DataConn
Dim CmdUpdateRecord
Dim MYSQL

Set DataConn = Server.CreateObject("ADODB.Connection")
Set CmdUpdateRecord = Server.CreateObject("ADODB.Recordset")

DataConn.Open "DBQ=" & Server.Mappath("../../databases/LeParede.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"
    
MYSQL = "SELECT Accom, HS, LS, MS, WE, SP, FROM Prices WHERE (Accom = " & request.form ("Accom") & ")"
    
CmdUpdateRecord.Open MYSQL, DataConn, 1, 3
    
CmdUpdateRecord.Fields("HS") = request.form("HS")
CmdUpdateRecord.Fields("LS") = request.form("LS")
CmdUpdateRecord.Fields("MS") = request.form("MS")
CmdUpdateRecord.Fields("WE") = request.form("WE")
CmdUpdateRecord.Fields("SP") = request.form("SP")
CmdUpdateRecord.Update
    
CmdUpdateRecord.Close
Set CmdUpdateRecord = Nothing
DataConn.Close
Set DataConn = Nothing
Response.Redirect "editprices2.asp"
%>

 

[dan-cat]

I use sql server not mysql so not sure whether the syntax is different.

Anyhow you have a comma after your last field name