How to paging the search results??

[SadeJade]

Hello,

I made a XML file that brings the results of a key search from SQL 2000 to XSL for display but I need to break those results in pages of ten !!

How can I do that? I should do that in the XSl or in the XML or at the SQL query? And how to do it in the appropriated language??

Thanks ;-)

J.

 

[martynj]

How are you accessing the data..ADO or XML Templates ??

I have a link for either so let me know!!

 

[connection]

Hi

the connection was made with an ASP string so, it's ADO, the XML call the string to connect and then use SQL strings to execute the SQL query

 

[SadeJade]

hello martynj,

I'm using a ODBC connection, I believe my problem is the correct use of recordset's, I type in the VBScript myRecord.RecordCount and doesn't work, so I try out myRecord.Count still doesn't work!!

Can you give me a tip?

J.