Type mismatch error on IF Statement

[sshafe]

Let me first say I am new to the vbscript environment. I have worked with 6.0 and .NET before, but I am having problems converting to this style.
I am getting the error Type Mismatch error on an IF statement line... What am I doing wrong? Please help

The code:
SQL_STATEMENT = "SELECT COUNT(*) FROM vbscript_test WHERE user_id = '" & _
strUserName & "' AND group_id = '" & strUserGroup & "';"
Set CheckUser = cnMcLDBA.Execute(SQL_STATEMENT)

If CheckUser = 0 Then ****This line has the error
Set Update = cnMcLDBA.Execute("INSERT INTO vbscript_test VALUES('" & _
strUserName & "','" & strUserGroup & "');&quot

 

[rtshort]

I can't swear to it but the sql statement is probably returning a string. To use it like: If CheckUser = 0 Then

you may have to change it to:

If CheckUser = CInt(0) Then

That way it will see 0 as a number and not a string. Rob
Just my $.02.

 

[sshafe]

That didn't work. Same error

 

[sshafe]

Just for anyone else who has this problem. I found the solution:

I was reading through a recordset and needing to check that:

Set CheckUser = cnMcLDBA.Execute("SELECT COUNT(*) FROM vbscript_test WHERE user_id = '" & _
strUserName & "' AND group_id = '" & strUserGroup & "';&quot
CheckUser.moveFirst 'Move the recordset to first position

If CheckUser(0) = 0 Then
Set Update = cnMcLDBA.Execute("INSERT INTO vbscript_test VALUES('" & _
strUserName & "','" & strUserGroup & "');&quot