Index: /trunk/psLib/src/db/psDB.c
===================================================================
--- /trunk/psLib/src/db/psDB.c	(revision 10668)
+++ /trunk/psLib/src/db/psDB.c	(revision 10669)
@@ -12,6 +12,6 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.119 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2006-12-06 03:01:42 $
+ *  @version $Revision: 1.120 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2006-12-13 01:42:51 $
  *
  *  Copyright (C) 2005-2006  Joshua Hoblitt, University of Hawaii
@@ -1437,8 +1437,19 @@
     // treat limit == 0 as "no limit"
     if (limit) {
-        limitString = psDBIntToString(limit);
-        psStringAppend(&query, " LIMIT %s", limitString);
+        limitString = psDBGenerateLimitSQL(limit);
+        psStringAppend(&query, " %s", limitString);
         psFree(limitString);
     }
+
+    return query;
+}
+
+psString psDBGenerateLimitSQL(psU64 limit)
+{
+    psString query = NULL;
+
+    psString limitString = psDBIntToString(limit);
+    psStringAppend(&query, " LIMIT %s", limitString);
+    psFree(limitString);
 
     return query;
Index: /trunk/psLib/src/db/psDB.h
===================================================================
--- /trunk/psLib/src/db/psDB.h	(revision 10668)
+++ /trunk/psLib/src/db/psDB.h	(revision 10669)
@@ -10,6 +10,6 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.32 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2006-12-06 03:01:42 $
+ *  @version $Revision: 1.33 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2006-12-13 01:42:51 $
  *
  *  Copyright 2005 Joshua Hoblitt, University of Hawaii
@@ -427,4 +427,14 @@
 );
 
+/** Generates an SQL "limit" statement
+ *
+ * This function generates an SQL fragment (not a whole usable query).
+ *
+ * @return psString:   A psString or NULL on failure
+ */
+psString psDBGenerateLimitSQL(
+    psU64 limit                         ///< result set row limit
+);
+
 /** converts an integer into a psString
  *