I want to write a method which accepts categoryid and returns a resultset.
Please tell me how do I write a method and call it to get the resultset..

Thanks

snip here....

Function GetCategoryIdResultSet(categoryId) as ADODB.Recordset
   ...<do all the dab code here>
   set rst = con.open(<sql statement>)
   GetCategoryIdResultSet = rst
End Functions

Is this you were looking for...

With Regards,
Raghavendra Mudugal

Thanks