Too few parameters. Expected 1

argh får hele tiden den her fejl

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/crm2/bruger/slet_bruger.asp, line 15



koden kommer her:

brug = Request.form("brugernavn")
getname = "SELECT brugernavn from brugere where brugerid ="&brug
set rs = Conn.Execute(getname)
bruger = rs("brugernavn")
getsalgsadmin = "SELECT * FROM kunder WHERE salgsadmin = '" & bruger & "'"
set rs2 = Conn.Execute(getsalgsadmin)

getprodadmin = "SELECT * FROM ordrereg WHERE prodadmin = '" & bruger & "'"
set rs3 = Conn.Execute(getprodadmin)  <--- line 15

hvis jeg udskriver sql strengen ser den sådan her ud:

SELECT * FROM ordrereg WHERE prodadmin = 'jong'