ShinNathan — Sat, 19 May 2001 09:13:35 +0000

Thank you very much

_Nathan.

Mark Hensler — Fri, 18 May 2001 18:22:18 +0000

"In SQL, can you tell it to select say, the first 20 results instead of selecting all or selecting by criteria?"

Yes... msSQL:
SELECT TOP 20 * FROM table_name WHERE ID>=40 ..blah blah blah

mySQL:
SELECT * FROM table_name WHERE... blah blah .... LIMIT 40,20

The mySQL query will return 20 records starting with record 40. The msSQL query will return 20 records starting with the record whose ID is 40. There not the same, but close.

pagenate... make into pages
Some links that may help:
http://msdn.microsoft.com/library/partbook/asp20/apagedresultsetexample.htm
http://msdn.microsoft.com/library/default.asp?URL=/library/wcedoc/adoce31/ado30ref_6.htm
http://msdn.microsoft.com/library/psdk/indexsrv/ixuwebqy_1mxx.htm

ShinNathan — Fri, 18 May 2001 08:52:51 +0000

Another quick question while I am here.

In SQL, can you tell it to select say, the first 20 results instead of selecting all or selecting by criteria?

For example I could say:

SELECT 20 FORM thisTable WHERE this ='that'

Thanks

ShinNathan — Fri, 18 May 2001 08:40:42 +0000

It is a recordset... What is pagenate?

Mark Hensler — Fri, 18 May 2001 08:30:32 +0000

Where is your data comnig from? a database? If so, we can use the recordset object to pagenate the results for you.