|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| Ack, anyone got a suggestion for LIMIT? |
| Author |
Message |
|
|
| Posted : 2007-06-21 15:41:21 |
I've searched high and low for this on the forums, and on google. Basically i'm making a php script that interacts with quickbooks via QODBC, but when I try to run a query like...
SELECT * FROM Customers LIMIT 10, 20
it doesn't work. Basically I need something with the functionality of LIMIT so I can set up pagination on a page (ie, next page buttons, first page shows rows 1 through 10, next shows 11 through 20, etc).
Can anyone help me out? ^_^
Thanks |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-06-21 16:05:56 |
The approach would be to do:
SELECT TOP 10 * from Customer Order by FullName
and then using the last FullName value from the query above.
SELECT TOP 10 * from Customer where FullName > 'Last Fullname Value' Order by FullName
and so on. |
|
|
|
|