update fejl i MySQL-script
Hej Exp'sJeg har lavet en side hvor brugere kan rette deres bruger-info. Men jeg får denne fejl:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.14-nt]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 'adresse= Kongevejen postnr= 2840 bopael= Holte msn= johs@themas
/vp/ret_bruger_exe.asp, line 21
Her er scriptet:
<%
Set conn = createobject("ADODB.Connection")
conn.open = "DRIVER={MySQL ODBC 3.51 Driver};"_
& "SERVER=localhost;"_
& "DATABASE=vp;"_
& "UID=root;PWD=;"
strSQL = "update bruger set navn= " & request.form("navn") & " pwd= " & request.form("pwd") & " adresse= " & request.form("adresse") & " postnr= " & request.form("postnr") & " bopael= " & request.form("bopael") & " msn= " & request.form("msn") & " icq= " & request.form("icq") & " hp_url= " & request.form("hp_url") & " mail= " & request.form("mail") & " selv_beskriv= " & request.form("selv_beskriv") & " where id = " & request.querystring("bruger")
conn.execute(strSQL)
conn.close
set conn = nothing
response.write "Du er blevet tilmeldt... ;-)"
%>
Hvad er der galt??
//themaster
