I think I understand what you are describing, but I would need more details or to look at the code to possibly help. From what you are describing it seems possible and it seems you are trying to do it correctly. You are clearly making a mistake somewhere, but without debugging it is hard to tell where.
Are you getting the correct results from your recordset? Is the session variable stored correctly when you display it on the page? You need to narrow down exactly where your problem originates in order to solve it.