faqts : Computers : Programming : Languages : PHP : Database Backed Sites : Sybase

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

10 of 21 people (48%) answered Yes
Recently 4 of 10 people (40%) answered Yes

Entry

How can I limit the number of records Sybase returns and have google like pages ([1] 2 3 ) ?

Dec 10th, 2001 02:31
Calin Uioreanu, Matthijs Matt,


use:
set rowcount <<number>>
This is not MySQL's LIMIT statement, but it's almost useful.
You reduce the traffic between the db server and PHP, but you have to 
consider that it's not a _real_ delimiter to the query