i need to have 2 record sets on a page. One is a set of all news - and I do a repeat region on 10 records. then off the side i want to show articles 10-20 in a different format. Anyone know how to do this?

Just create two recordsets (rsNews1 and rsNews2) and do your stuff.

ya, but way sql do i use to start my recordset at the 10th record? I can't get LIMIT to work like in MySql

You can do it with one recordset and if then statement.
Something like:
<%
Counter = 0
While (Not RecordsetName.EOF) And (Counter < 20)
If Counter < 10 Then
*** Code for format 1 ***
Else
*** Code for format 2 ***
End if
Counter = Counter + 1
RecordsetName.MoveNext()
Wend

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
ya, but way sql do i use to start my recordset at the 10th record? I can't get LIMIT to work like in MySql


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager