filemaker pro 8.5 and php

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 392,007 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,204 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser:

Thread Tools Display Modes

Views: 1606 | Replies: 0

•

Join Date: May 2007

Posts: 5

Reputation: redcoder07 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

redcoder07 redcoder07 is offline

Offline

Newbie Poster

filemaker pro 8.5 and php

May 31st, 2007

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