Subject | PreparedStatement and group by ? |
---|---|
Author | Steven Jardine |
Post date | 2004-03-25T21:55:37Z |
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
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