Index: temp/trunk/html/admin/products/index.php
===================================================================
--- temp/trunk/html/admin/products/index.php	(revision 10258)
+++ temp/trunk/html/admin/products/index.php	(revision 10259)
@@ -262,5 +262,5 @@
 
 			// ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
-			$objQuery->setlimitoffset($page_max, $startno);
+			//$objQuery->setlimitoffset($page_max, $startno);
 			// ɽ¼¨½ç½ø
 			$objQuery->setorder($order);
@@ -275,5 +275,5 @@
 				$where_tmp .= sfQuoteSmart($arrval[$i - 1]) . $arrWhere[$i];
 			}
-			$arrViewWhere["&&noncls_where&&"] = $where_tmp . " " . $objQuery->order . " " .  $objQuery->option;	
+			$arrViewWhere["&&noncls_where&&"] = $where_tmp . " " . $objQuery->order . " " .  $objQuery->setlimitoffset($page_max, $startno, true);
 			
 			sfprintr($objQuery->option);
Index: temp/trunk/data/class/SC_Query.php
===================================================================
--- temp/trunk/data/class/SC_Query.php	(revision 7999)
+++ temp/trunk/data/class/SC_Query.php	(revision 10259)
@@ -121,8 +121,15 @@
 	}
 	
-	function setlimitoffset($limit, $offset = 0) {
+	function setlimitoffset($limit, $offset = 0, $return = false) {
 		if (is_numeric($limit) && is_numeric($offset)){
-			$this->option.= " LIMIT " . $limit;
-			$this->option.= " OFFSET " . $offset;
+			
+			$option.= " LIMIT " . $limit;
+			$option.= " OFFSET " . $offset;
+			
+			if($return){
+				return $option;
+			}else{
+				$this->option.= $option;
+			}
 		}
 	}