[otrs-cvs] otrs/Kernel/System DB.pm,1.152,1.153

"CVS commits notifications of OTRS.org" <[email protected]>
Newsgroups gmane.comp.otrs.cvs
Message-ID <[email protected]>
Comments:
Update of /home/cvs/otrs/Kernel/System
In directory lancelot:/tmp/cvs-serv3621/Kernel/System

Modified Files:
	DB.pm 
Log Message:
Added support for limiting result sets in the SQL Server DB Driver.

Author: mb

Index: DB.pm
===================================================================
RCS file: /home/cvs/otrs/Kernel/System/DB.pm,v
retrieving revision 1.152
retrieving revision 1.153
diff -2 -u -d -r1.152 -r1.153
--- DB.pm	5 Dec 2012 11:09:01 -0000	1.152
+++ DB.pm	11 Dec 2012 06:19:42 -0000	1.153
@@ -560,4 +560,7 @@
             $SQL .= " LIMIT $Limit";
         }
+        elsif ( $Self->{Backend}->{'DB::Limit'} eq 'top' ) {
+            $SQL =~ s/^SELECT/SELECT TOP $Limit/i;
+        }
         else {
             $Self->{Limit} = $Limit;
---------------------------------------------------------------------
OTRS mailing list: cvs-log - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/cvs-log
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/cvs-log
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.