Originally posted by Greg Belyea:
select * from minwage where effevtive like '%77%' and province like '%N%' order by 'wage' ASC
I think order by 'wage' is your problem, because in sql order by clause is always followed by a column name not a
String.
if you really want to set order by dynamically I would recommend to use column sequence in query because in prepared statement setInt for Order by would work but setString I am not sure
make your query somthing like
select a,b,c from mytable order by 1
above query is equivalent to
select a,b,c from mytable order by a
OR
select a,b,c from mytable order by 2
and this is equivalent to
select a,b,c from mytable order by b
hope this helps to solve your problem of oder by.
thanks
[ March 15, 2005: Message edited by: Shailesh Chandra ]