Member Avatar for redcoder07
redcoder07 0 Newbie Poster

How do I limt the records extracted from filemaker using the query "Select.... LIMIT 5" ? Example: select * from tablename limit 10.

I connect the filemaker pro 8.5 via ODBC and use php to display the records.A small amount of records(1 or 2 rows) will display the records, but a large amount of records (more than 10 rows) will not display on the page and give fatal error:exceed execution time. Therefore I am thinking of limit the number of record(or row) displayed to 5 instead of a whole long list.

I tried use the LIMIT in the query but it give error:

Warning: odbc_exec(): SQL error: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL, SQL state S1000 in SQLExecDirect in c:\program files\easyphp1-8\www\filemaker\mgrpartsrecord.php on line 16

  • 1 Contributor
  • 0 Replies
  • 88 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.