CMS MADE SIMPLE FORGE

Questions

 
Back Back to List

[#1400] SQL syntax for LIMIT doesn't work for PostgreSQL

avatar
Created By: Mike Beckish (mbeckish)
Date Submitted: Tue Mar 13 16:06:43 -0400 2007

Assigned To:
Version: None
CMSMS Version: None
Severity: Major
Resolution: Accepted
State: Open
Summary:
SQL syntax for LIMIT doesn't work for PostgreSQL
Detailed Description:
Anywhere LIMIT is used (like getting the list of questions to display) is broken
when using PostgreSQL as your CMSMS DBMS.

Fix:

Files: function.admin_questionstab.php, function.default_summary.php

For PostgreSQL, change all occurrences of "LIMIT $startelement,$pagelimit" to
"LIMIT $pagelimit OFFSET $startelement"


History