classic ASP query issue
Posted on 2014-01-16
I have a classic ASP page where I was trying to pull in a text string of comma separated numbers, then pull the names for each numeric value from another db table, and display the text names in a comma separated list on the webpage.
I'm in over my head with the syntax. Is this a fairly routine piece of code?
So I have session variable: session("UserTypes") that would be something like 1,3,5,7.
And I have a db table called AccessTypes that has AccessTypeID and AccessName.
How would I turn 1,2,5,7 into AccessName1, AccessName2, AccessName5, and AccessName7 and write that value to html?