List using Calendar

tads · **Posted:** Wed Nov 05, 2003 12:23 pm

Hi...

I

dimas · **Posted:** Wed Nov 05, 2003 4:11 pm

First, you are just building invalid query (because it will contain WHERE clause three times).
Second, you should never concatenate _parameters_ to query string

Public List listUsers(Calendar dtInitial, Calendar dtFinal)
{
String query = "from User u where u.dtInclusion >= :dtInitial and u.dtInclusion >= :dtFinal";
query.setCalendar("dtInitial", dtInitial);
query.setCalendar("dtFinal", dtFinal);

sess.createQuery(query);
}

dimas · **Posted:** Wed Nov 05, 2003 4:12 pm

Ooops

Code:

Public List listUsers(Calendar dtInitial, Calendar dtFinal) 
{ 
    String queryText = "from User u where u.dtInclusion >= :dtInitial and u.dtInclusion >= :dtFinal"; 
    Query query = sess.createQuery(queryText); 
    query.setCalendar("dtInitial", dtInitial); 
    query.setCalendar("dtFinal", dtFinal); 

    return query.list()
}

dimas · **Posted:** Wed Nov 05, 2003 4:15 pm

Although I think dtFinal comparisong operator should be <= not >= ...