Det skall inte vara
'response.write(SQLQuery)
utan
response.write SQLQuery
Med ' menas att det är en kommentar.
Byt ut det och meddela oss vad det står.
Skulle tippa på att det är user_id som spökar.
Andreas
[Redigerat av AG den 24 sep 2000]
Frågan#1
----ERROR------------------------------
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
--resopnse.write (SQLQuery)-------------------
UPDATE tblUser_public SET show_firstname = '1',show_lastname = '1',show_ort = '1',show_occupation = '1',show_food = '1',show_mail = '1',show_icq = '1' where user_id = 60;
---MIN KOD--------------------------------
SQLQuery = "UPDATE tblUser_public SET "
SQLQuery = SQLQuery & "show_firstname = '" & request.form("cbfirstname") & "',"
SQLQuery = SQLQuery & "show_lastname = '" & request.form("cblastname") & "',"
SQLQuery = SQLQuery & "show_ort = '" & request.form("cbort") & "',"
SQLQuery = SQLQuery & "show_occupation = '" & request.form("cboccupation") & "',"
SQLQuery = SQLQuery & "show_food = '" & request.form("cbfood") & "',"
SQLQuery = SQLQuery & "show_mail = '" & request.form("cbmail") & "',"
SQLQuery = SQLQuery & "show_icq = '" & request.form("cbicq") & "'"
SQLQuery = SQLQuery & " where user_id = " & Request.form("id") & ";"
'response.write(SQLQuery)
Set rs = OBJdbConnection.Execute(SQLQuery)
