Fixes ThatRendle#301 - Whitespace issue

richardhopton · richardhopton · commit ea19abe2ed93 · 2013-08-15T17:50:25.000+01:00
diff --git a/Simple.Data.SqlServer/SqlQueryPager.cs b/Simple.Data.SqlServer/SqlQueryPager.cs
@@ -48,8 +48,9 @@ public IEnumerable<string> ApplyPaging(string sql, string[] keys, int skip, int
             var rest = Regex.Replace(fromEtc, @"^from (\[.*?\]\.\[.*?\])", @"");
             builder.Append(rest);
             
-            builder.AppendFormat(" AND [_#_] BETWEEN {0} AND {1} ", skip + 1, skip + take);
-            builder.Append(groupBy);
+            builder.AppendFormat(" AND [_#_] BETWEEN {0} AND {1}", skip + 1, skip + take);
+            if (!string.IsNullOrWhiteSpace(groupBy))
+                builder.AppendFormat(" {0}", groupBy);
             yield return builder.ToString();
         }
 
