Merge pull request ThatRendle#303 from markrendle/301

richardhopton · richardhopton · commit 3713523f8056 · 2013-08-15T09:51:19.000-07:00
Fixes ThatRendle#301 - Whitespace issue
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();
         }
 
