[JB4]

Hey guys,

Just wondering - we've got a setup that all works - SQL query control dropped onto the page that populates a database grid.

However, we now wish to change the query depending on a stored SESSION variable.

So - whereas the SQL control says something along the lines of

SELECT * FROM database1.table1, we need it to be something along the lines of SELECT * FROM $_SESSION['databasename'].table - is this doable?

Cheers in advance,
John