Query Parameters

[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

[405hp]

Have you tried it?

I would imagine that it would work one way or another. You can always eval it if the var's don't work.