Display all records in rs EXCEPT first row 1

[jayraykay]

Hello.

I have created a simple result set that displays all rows and fields in a table ordered by a timestamp field descending.

select * from tablename order by timefield desc

I need to display all the records except the first row in this set.

Can someone be of assistance?

Thank you.

 

[vongrunt]

display" is client issue. Can you simply skip first record then loop over rest, e.g.:

If not RS.Eof Then 
	RS.moveNext
	
	Do While not RS.Eof
		-- display record
		RS.moveNext
	Loop
	
End If

------
Math problems? Call 0800-[(10x)(13i)^2]-[sin(xy)/2.362x]

 

[donutman]

If you don't want to handle it at the client as you should:

[Blue]SELECT[/Blue] [Gray]*[/Gray] [Blue]FROM[/Blue] tablename 
   [Blue]WHERE[/Blue] ID[Gray]<[/Gray][Gray]>[/Gray][Gray]([/Gray][Blue]SELECT[/Blue] [Blue]TOP[/Blue] 1 ID [Blue]FROM[/Blue] tablename 
                 [Blue]ORDER[/Blue] [Blue]BY[/Blue] timefield [Blue]DESC[/Blue][Gray])[/Gray]
   [Blue]ORDER[/Blue] [Blue]BY[/Blue] timefield [Blue]DESC[/Blue]

-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[jayraykay]

perfect donutman

thanks