Feltyp:Hjälp med ASP & MySQL.
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[MySQL][ODBC 3.51 Driver][mysqld-3.23.55-max-nt]You have an error in your SQL syntax near '[name]='Main', [desc]='Main-sidor. .' WHERE id=2' at line 1
/new/admin/default.asp, line 74
query = "UPDATE tblCat SET "
query = query & "[name]='" & Request.Form("name") & "'"
query = query & ", [desc]='" & Request.Form("desc") & "' WHERE id=" & request.form("id")
db.execute(query)
helt utskriven mysql sats:
UPDATE tblCat SET [name]='Main', [desc]='Main-sidor. .' WHERE id=2