Select Column using Session Variable

[dmh5]

I have set a session variable to hold the name of a column dependent on who the user is. Is it possible to use a session variable to select a column in a database table? If so, how? Does it need a where statement?

Something like this?:

<cfquery name="rsSelectColumn" datasource="Test">
SELECT Column 1, Column 2, Column 3 = Session Variable
FROM tbl_data
</cfquery>

Thanks,
Dave

[cf_dev2]

Double post
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=6&threadid=1313173

[Guest]

Yes you can use session variables.

<cfquery name="getUser" datasource="test">
SELECT Col1, Col2, Col3
FROM myTable
WHERE Col3 = #Session.variable#
</cfquery>

[cf_dev2]

I don't think that's exactly what they're trying to do. But if you read the other thread .. you can see what was suggested so far.

[SafariTECH · Accepted solution]

I think you want to do this, if the value in the session variable is the actual column name:

<cfquery name="rsSelectColumn" datasource="Test">
SELECT Column 1, Column 2, #Session Variable# AS Col3
FROM tbl_data
</cfquery>

this way you can call any column stored in the session variable, and it will always be usable from the QUERY as COL3 regardless of what column you used.


If that is what you want to do - it IS that simple.

:-)

Sometimes we over think things too much.

[cf_dev2]

> SELECT Column 1, Column 2, #Session Variable#

That's what I already suggested on the other thread

Did anyone read the comments on this thread? :-)

[dmh5]

Thanks! Works like a charm.