Command Object

i build my sql string by using bunch of if-end if statements, after storing the whole SQL string into variable strSQL i put into the command object's CommandText property like so:

objCommand.CommandText = strSQL
Set rsRec = objCommand.Execute 'rsRec being a recordset

then i want to be able to display the data:
While Not rsRec.EOF
Response.Write(rsRec("FIRST_NAME") & " " & rsRec("LAST_NAME") & " - " & rsRec("FIRM_NAME") & _
" " & rsRec("EMAIL") & " " & rsRec("CITY") & "<BR>")
rsRec.MoveNext
Wend

but this gives me an error saying:
Object doesn't support this property or method: 'CommandText'