Created Codestriker topic at:
http://codestriker.sourceforge.net/cgi-bin/codestriker.pl?topic=2729126&action=view
User: sits
Date: 05/07/14 02:54:16
Modified: lib/Codestriker/Model File.pm
Log:
Remove nested select so SQL Server works again.
Index: File.pm
===================================================================
RCS file: /cvsroot/codestriker/codestriker/lib/Codestriker/Model/File.pm,v
retrieving revision 1.23
retrieving revision 1.24
diff -u -r1.23 -r1.24
--- File.pm 18 Sep 2004 00:54:19 -0000 1.23
+++ File.pm 14 Jul 2005 09:54:15 -0000 1.24
@@ -113,14 +113,21 @@
# Store the results in the referenced arrays.
if ($success) {
my @data;
+ my @sequence;
while (@data = $select_file->fetchrow_array()) {
push @$filename_array_ref, $data[0];
push @$revision_array_ref, $data[1];
push @$offset_array_ref, $data[2];
push @$binary_array_ref, $data[3];
+ push @sequence, $data[4];
+ }
+ $select_file->finish();
+ # This has to be called outside the loop above, as SQL Server
+ # doesn't allow nested selects... gggrrrr.
+ foreach my $file_id (@sequence) {
# Now get the number of lines affected in this file
- my $numchanges =
Codestriker::Model::Delta->get_delta_size($topicid, $data[4]);
+ my $numchanges =
Codestriker::Model::Delta->get_delta_size($topicid, $file_id);
push @$numchanges_array_ref, $numchanges;
}
-------------------------------------------------------
This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening
July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual
core and dual graphics technology at this free one hour event hosted by HP,
AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar
_______________________________________________
Codestriker-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/codestriker-commits
