Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select last 10 records
Message
From
17/09/2004 15:59:43
 
General information
Forum:
Internet
Category:
Active Server Page
Miscellaneous
Thread ID:
00943399
Message ID:
00943606
Views:
15
>hi all
>i am trying to select out the last 10 records entered by a user in a table. the db is foxpro and the code is called from an asp page. anything i try like "DESC LIMIT 3", LIMIT, is not working, any ideas?
>Slán
>~M
Hi Mark

If you meant, by SQL-select.. You can try .."where recno() =< reccount()-10" on its option..


HTH

Claudio
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform