K
kbrad
I am using the following code in asp to select some data from an access db.
recSel is defined and set further up my webpage, as is rsUpdate User.
I cannot work out how to get past this error message
Too few parameters. Expected 1.
Can anyone see the problem?
strSQL = "SELECT tblUserDetails.UserRecId, tblUserDetails.UserName, " _
& "tblUserDetails.UserPw, tblUserDetails.UserEmailAddress, " _
& "tblUserDetails.UserFirstName, tblUserDetails.UserSurname, " _
& "tblUserDetails.UserPhoneNo, tblUserDetails.UserCompany " _
& "FROM tblUserDetails" _
& " WHERE tblUserDetails.UserName =" & recSel
rsUpdateUser.Open strSQL, adoCon, adOpenDynamic, adLockOptimistic
recSel is defined and set further up my webpage, as is rsUpdate User.
I cannot work out how to get past this error message
Too few parameters. Expected 1.
Can anyone see the problem?
strSQL = "SELECT tblUserDetails.UserRecId, tblUserDetails.UserName, " _
& "tblUserDetails.UserPw, tblUserDetails.UserEmailAddress, " _
& "tblUserDetails.UserFirstName, tblUserDetails.UserSurname, " _
& "tblUserDetails.UserPhoneNo, tblUserDetails.UserCompany " _
& "FROM tblUserDetails" _
& " WHERE tblUserDetails.UserName =" & recSel
rsUpdateUser.Open strSQL, adoCon, adOpenDynamic, adLockOptimistic