I keep getting the following error using LIMIT in cfquery. I am trying to to build a pagination...
I dont want to show more than 5 links at a time but I am stuck on the LIMIT error when cfquery queries the access mdb
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'f_id = '1' LIMIT 0, 25'.
I have tried it by moving the LIMIT above and below the ORDER BY and same error. What am I doing wrong here?
<cfquery name="gethist" datasource="#dsn#" result="get_data">
where f_id = '#f_id#'
LIMIT #start_record#, #records_per_page#
ORDER BY tid