Using one recordset multiple times in Classic ASP

See more:

ASP

Dear Friends,

I am working on a page which is in Classic ASP.
I need to execute a query and bind the data to combo box.

Now I have 3 combo box, which all 3 need to be filled with same data which is retrieved from query.
So i need to execute the query 3 times, is there any option to load the recordset only once and use it multiple times in classic ASP.

Please guide me on the same.