Re: abator: dynamic order by

2006-08-11 Thread Thomas Karl Schwaerzler
: OdmCustomerExample example = new OdmCustomerExample(); List answer = dao.selectByExample(example, "FIRST_NAME asc, LAST_NAME desc"); Jeff Butler On 8/11/06, Thomas Karl Schwaerzler <[EMAIL PROTECTED]> wrote: hello, i'm looking for something that allows me to use a dynamic ord

Re: abator: dynamic order by

2006-08-11 Thread Jeff Butler
, "FIRST_NAME asc, LAST_NAME desc");   Jeff Butler  On 8/11/06, Thomas Karl Schwaerzler <[EMAIL PROTECTED]> wrote: hello,i'm looking for something that allows me to use a dynamic order by valuein abator. the method could look something like this:List getCustomersOrdered(Long groupId, Stri

Re: abator: dynamic order by

2006-08-11 Thread Gwyn Evans
06, Thomas Karl Schwaerzler <[EMAIL PROTECTED]> wrote: hello, i'm looking for something that allows me to use a dynamic order by value in abator. the method could look something like this: List getCustomersOrdered(Long groupId, String orderColumn, String ascDesc) ..where orderColumn i

abator: dynamic order by

2006-08-11 Thread Thomas Karl Schwaerzler
hello, i'm looking for something that allows me to use a dynamic order by value in abator. the method could look something like this: List getCustomersOrdered(Long groupId, String orderColumn, String ascDesc) ..where orderColumn is a column name and ascDesc is either 'ASC'

Re: Dynamic Order By

2006-07-10 Thread Jeff Butler
m: "Nathan Maves" < [EMAIL PROTECTED]>To: <user-java@ibatis.apache.org>Sent: Monday, July 10, 2006 11:56 PMSubject: Re: Dynamic Order By > Just a thought but I would not query the DB every time you need to re-> sort your table.  I would do all of the sorting in plain

Re: Dynamic Order By

2006-07-10 Thread Nicolas Duroc
e have to do it in a better way on java/javascript. - Original Message - From: "Nathan Maves" <[EMAIL PROTECTED]> To: Sent: Monday, July 10, 2006 11:56 PM Subject: Re: Dynamic Order By > Just a thought but I would not query the DB every time you need to re- > sort you

Re: Dynamic Order By

2006-07-10 Thread Nathan Maves
Just a thought but I would not query the DB every time you need to re- sort your table. I would do all of the sorting in plain old java, or better yet why not do it client side via javascript? Nathan On Jul 10, 2006, at 2:25 PM, Nicolas Duroc wrote: Hello, I have a jsp page who displays

Dynamic Order By

2006-07-10 Thread Nicolas Duroc
Hello,   I have a jsp page who displays a table of objects, and I would like to sort the table in function of the columns, I use so an "order by".I tried to use a select with the "ordered column" in parameter in the SQL Map, but it didn't work. The "ORDER BY" was not "executed". I found few explana