I am trying to add code to check for duplicate userID.

Set cmdDC = Server.CreateObject("ADODB.Command")
cmdDC.ActiveConnection = DataConnection

'-- default SQL
SQL = "SELECT * FROM UserRegistration"

If Request.Form("name") <> "" Then
SQL = "SELECT * FROM Register WHERE " & _
"Register.userID='" & strUserID & "' AND " & _
"Register.password ='" & strPassword & _
"' OR Register.email ='" & strEmail & "'"
End If

cmdDC.CommandText = SQL
Set RecordSet = Server.CreateObject("ADODB.Recordset")



'-- Cursor Type, Lock Type

'-- ForwardOnly 0 - ReadOnly 1

'-- KeySet 1 - Pessimistic 2

'-- Dynamic 2 - Optimistic 3

'-- Static 3 - BatchOptimistic 4



RecordSet.Open cmdDC, , 0, 2




If Not RecordSet.EOF Then

If RecordSet.fields("userID")=strUserID Then

Response.Redirect "usernamerror.asp"

Else

Response.Redirect "userpassworderror.asp"

End If



It does not work properly! It doesn't even check the userID. But if I change the If RecordSet.fields("userID")=strUserID Then to say If RecordSet.fields("email")=stremail then it works properly.

What shall I do?

Is the problem within the RecordSet.Open cmdDC, , 0, 2?