Any programmers? Need help!!!

[BlackJetta]

Hi, everybody...
Straight ahead, I'm looking for someone who has an experience with using bind variables with ADO and VB6. I'm trying to pass the list of parameters on the where - in () clause as a string into a bind variable, such as this:

...

objCm.Parameters.Append _
objCm.CreateParameter( "prVar3", adVarChar, adParamInput, 100, "'blah1', 'blah2', 'blah3'" )

strSql = " SELECT * FROM table "
strSql = strSql & " WHERE param in ( : prVar3)"

...

After the execution of the command, the recordset is returned empty.

However, if I run the SQL query directly in TOAD like htis:

SELECT * FROM table
WHERE param in ('blah1', 'blah2', 'blah3')

I have so many records returned.

NOTE: I did test the code with the other cases, such as
using this

objCm.Parameters.Append _
objCm.CreateParameter( "prVar3", adVarChar, adParamInput, 100, "blah1" )

and had the records returned into the recordset.

Any ideas? may be someone had to deal with something like that?

Thanks in advance!!!