User: sits
Date: 07/09/25 02:23:50
Modified: lib/Codestriker/Model Metrics.pm
Log:
Fix SQL Server again, which was broken in RC2 due to the incorrect use
of the LOWER() function on ntext fields.
Index: Metrics.pm
===================================================================
RCS file: /cvsroot/codestriker/codestriker/lib/Codestriker/Model/Metrics.pm,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -r1.14 -r1.15
--- Metrics.pm 18 Aug 2007 04:14:37 -0000 1.14
+++ Metrics.pm 25 Sep 2007 09:23:49 -0000 1.15
@@ -807,9 +807,9 @@
'topichistory.version, ' .
'topichistory.repository, ' .
'project.name, ' .
- 'LOWER(topichistory.reviewers),
' .
- 'LOWER(topichistory.cc), ' .
-
'LOWER(topichistory.modified_by_user) ' .
+ 'topichistory.reviewers, ' .
+ 'topichistory.cc, ' .
+ 'topichistory.modified_by_user
' .
'FROM topichistory, project ' .
'WHERE topichistory.topicid = ?
AND ' .
'topichistory.projectid =
project.id ' .
@@ -830,9 +830,9 @@
version=>$version,
repository=>$repository,
project=>decode_utf8($project),
- reviewers=>$reviewers,
- cc=>$cc,
- modified_by=>$modified_by
+ reviewers=>lc($reviewers),
+ cc=>lc($cc),
+ modified_by=>lc($modified_by)
);
push @history_list, \%entry;
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Codestriker-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/codestriker-commits
