henkpoldergraaf
|
Posted: 06/09/2004, 7:22 AM |
|
Hi ive got a problem my project give error ERROR: LIMIT #,# syntax is not supported in know i should use limit # so what am i doing wrong is this a bug in css 2.3?
please help
|
|
|
Support Representative
|
Posted: 06/10/2004, 2:06 AM |
|
Hello,
This is a known problem with CCS2.3 Beta.
Please submit a support request at http://support.codecharge.com/support_new.asp
And we’ll provide a fix for this issue.
Regards,
CCS Support
|
|
|
arian
Posts: 11
|
Posted: 06/12/2004, 4:54 AM |
|
A temporary solution, until CCS Support will provide a fix is to modify the optimize function in common.php as follows:
function OptimizeSQL($SQL)
{
// $PageSize = (int) $this->PageSize;
// if (!$PageSize) return $SQL;
// $Page = $this->AbsolutePage ? (int) $this->AbsolutePage : 1;
// $SQL .= " LIMIT " . $PageSize . "," . (($Page - 1) * $PageSize);
return $SQL;
}
|
|
|
|