VBScript and ASP: ADO PROBLEM: Error '800a0bb9'; ADO Filter Property Error

The following throws ADODB.Recordset Error '800a0bb9' ("Arguments are of the wrong type, are out of acceptable range or are in conflict with one another.") in VBScript:

objListRst.Filter = objH1Rst.Fields(&quot;filter&quot;)

This is because the Filter property of ADO expects a string literal. This error can be avoided with implicit conversion:

objListRst.Filter = objH1Rst.Fields(&quot;filter&quot;) & vbNullString

or explicit conversion:

objListRst.Filter = Cstr(objH1Rst.Fields(&quot;filter&quot;))

mod date: 2001-05-27T01:12:57.000Z