Hi guys,
I don't know whether this is feasible or not. But here is my problem
I have a session variable which has database field names in a particular order and this variable is generated dynamically, I dont know what is in that variable and in what order. What I have to do is display my results in the order they are in the session variable. So for example if my session varialbe contains
session.sv = "Id,Name,Address,Phone,City,Location"
I am using this directly in my query as
select #session.sv# from details
And I want to display the records only in that particular order i.e Id, Name, Address, Phone, City and Location, this order is dynamic. So It can be City first, Address second etc...
Hope someone can tell me how to solve this issue.
Thanks in advance.