Problem med insert i Mysql data
Alle felter er af typen textreponse.write(sql):
Insert Into User(Fn,En,U,P,E) Values('asas','asas','sas','111','ssss@hhh.fg')
fejlmeddelelse:
ADODB.Connection.1 error '80004005'
SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near 'User(Fn,En,U,P,E) Values('asas','asas','sas','111','ssss@hhh.fg')' at line 1
/testupload.asp, line 25
Kode:
Conn.Open conStr
sql = "Insert Into User(Fn,En,U,P,E) Values('"
sql = sql & Request.Form("FN") & "','"
sql = sql & Request.Form("EN") & "','"
sql = sql & Request.Form("U") & "','"
sql = sql & Request.Form("P") & "','"
sql = sql & Request.Form("E") &"')"
Conn.Execute(sql)
' Rydder op i connection objekt
Conn.Close
Set Conn = Nothing%>
Someone please tell me what the F... is wrong
