SELECT a subset of records in correct order 1

[ChrisRChamberlain]

Hi all

It's Friday and am suffering from brain failure.

The following code selects records 180 to 200 from the query but in descending order.

All that's required is to select the records in ascending order within the SELECT... code block

[COLOR=blue]lnRows = 20
lnOffset = 200

SELECT TOP lnRows company;
[tab]FROM C:\tables\contacts;
[tab]WHERE company IN;
[tab](SELECT TOP lnOffset company FROM C:\tables\contacts ORDER BY company ASC);
[tab]ORDER BY company DESC;
[tab]INTO CURSOR temp[/color][COLOR=green] && Correct records in reverse order[/color]

Presumably another WHERE... etc?

TIA

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander.com
PDFcommander.co.uk

 

[Olaf Doschke]

Ah I see.

It's querying all the data, then just not fetching all to PHP, but only $rowsPerPage records from an $offset.

Bye, Olaf.