kan ikke update min db
hej exp.jeg kan ikke update min db for denne fejl:
----------------------------------
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/zubnet.dk/update_profil.asp, line 11
her er asp-coden:
---------------------------------
<%
Const adOpenKeyset = 1
Const adLockOptimistic = 3
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../db/db.mdb") & ";UID=admin;PWD=;"
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "UPDATE DISTINCTROW * From users"
rs.Open strSQL,recordset
'response.write strSQL
rs("Username") = Request.form("bnavn")
rs("Password") = Request.form("pas")
rs("RigtigNavn") = Request.form("rnavn")
rs("Email") = Request.form("email")
rs("vejogNr") = Request.form("vejognr")
rs("postnr") = Request.form("postnr")
rs("telefon") = Request.form("telefon")
rs("mobil") = Request.form("mobil")
rs.Update
rs.Close
Set rs = Nothing
Conn.Close
set Conn = Nothing
%>
og den linen så sider fejl er denne linen
11. = rs.Open strSQL,recordset
håber i kan hjælpe mig
/rene/
