I have trying to create a sql query the displays from recod two and ill use the repeat region bit in dreamweaver to show the rest after it, its basically a news secition that record one (the lastest posted) is styled diferent to the rest, im not sure if it need to be a sql thing in my record set or a asp thing in my code, any ideas out there

Cheers Paul

Edited by - The Sluap on 31 May 2005 19:12:17

just do your repeat region as normal and then look for the code like this

<pre id=code><font face=courier size=2 id=code>
&lt;%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = 4
Repeat1__index = 0
rsArticles_numRows = rsArticles_numRows + Repeat1__numRows
%&gt;
</font id=code></pre id=code>

and change Repeat1__index = 0

to

Repeat1__index = 2 (to start at record id 2)

regards

Dave Thomas
<b>DMX Zone Manager</b>

thx
i did that and it still just displays all my records, it does not start at record 2

any ideas?

I do not know if this will help or if you already solved your problem, but, just in case here we go:

&lt;%
Dim rsDisplaytest__MMColParam
rsDisplaytest__MMColParam = "1"
If (Request("MM_EmptyValue" &lt;&gt; "" Then
rsDisplaytest__MMColParam = Request("MM_EmptyValue"
End If
%&gt;
&lt;%
Dim rsDisplaytest
Dim rsDisplaytest_numRows

Set rsDisplaytest = Server.CreateObject("ADODB.Recordset"
rsDisplaytest.ActiveConnection = MM_connCMS_STRING
rsDisplaytest.Source = "SELECT intPostID FROM tblPosts WHERE intPostID &lt;&gt; " + Replace(rsDisplaytest__MMColParam, "'", "''" + " ORDER BY intPostID ASC"
rsDisplaytest.CursorType = 0
rsDisplaytest.CursorLocation = 2
rsDisplaytest.LockType = 1
rsDisplaytest.Open()

rsDisplaytest_numRows = 0
%&gt;


Cheers,

Javier

i have been told it is best to do this in asp not in the query any idea's

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
thx
i did that and it still just displays all my records, it does not start at record 2

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

i use this quite a lot for headlining certain records.

you could always just use

WHERE myrecordid NOT 1

in your query.

regards

Dave Thomas
<b>DMX Zone Manager</b>

This works great but is is only not showing the ID number i choose not the record, as they all have diferent id numbers the latest is not always 1 etc etc

any ideas?
Cheers Paul

this should do the trick

SELECT field FROM table WHERE field NOT IN (SELECT TOP 1 field FROM table)

SELECT *
FROM tbl_news
ORDER BY news_date DESC

this is what i have atm how would i include the above cheers

SELECT * FROM tbl_news WHERE autonumberfield NOT IN (SELECT TOP 1 autonumberfield FROM tbl_news)
but you could have guessed that if u put a little effort in <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>