ASP & SQL Server uniqueidentifier connundrum

[ChainsawJoe]

hey all - I have a recordset already returned from a VB obj which I cannot change, but need to limit the records to a specific set of IDs. For this I'm using rs.filter - seems to work perfectly if I use

rs.filter = "username like 'a%'

but if I use

rs.filter = "ID in (select blahblah as ID from blah)"

where ID and blahblah are UniqueIdentifiers, then I get Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

I know the SQL specified in the filter works, since it's fine thru SQL Query Analyser.

I believe the problem to be in how uniqueidentifiers are used thru ASP. Something's not clicking here - any clues?

 

[codestorm]

My guess would be that the problem is going to get records from table blah. <insert witticism here>
codestorm

 

[ChainsawJoe]

found out what it was - ASP filter doesn't support &quot;in&quot; or subqueries . . . lovely . .