Update of /cvsroot/dithaka/base/src/org/dithaka/messaging
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv20907/src/org/dithaka/messaging
Modified Files:
Forum.java
Log Message:
Lowering the forum names so that the comparison in the select is case insensitive.
Index: Forum.java
===================================================================
RCS file: /cvsroot/dithaka/base/src/org/dithaka/messaging/Forum.java,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** Forum.java 10 Oct 2005 14:44:21 -0000 1.3
--- Forum.java 23 Nov 2005 14:25:36 -0000 1.4
***************
*** 387,391 ****
public static Forum getForum(String address) throws PersistenceException {
! String sqlQuery = "FROM Forum WHERE fullMailAddress LIKE '" + address
+ "'";
Forum forum = (Forum) PersistenceService.findOne(sqlQuery);
--- 387,391 ----
public static Forum getForum(String address) throws PersistenceException {
! String sqlQuery = "FROM Forum WHERE lower(fullMailAddress) LIKE '" + address.toLowerCase()
+ "'";
Forum forum = (Forum) PersistenceService.findOne(sqlQuery);
|
