Subject PreparedStatement and group by ?
Author Steven Jardine
I have a PreparedStatement and I would like to have a place holder
in the group by clause. I have looked around and it looks like I
need a bind variable instead of a place holder. Is there anyway
with FirebirdSQL to use a bind variable and then pass the proper
value in based on some user input?

I tried this:

select * from customers where order by ?

It looks like this might work but I am not sure if I can set the
bind variable dynamically:

select * from customers where order by :column

Is this possible? Thanks.

Steve