show all records apart from First

[Moragreid]

This may be really easy - but can anyone tell me how to create a record set to
show all records except the first record.
I would use the primary key ID but it may change with adding and deleting of
records. So just to show all except the lowest ID

any ideas?

[Grant Berkeley]

You could try this

<%
Recordset.MoveNext
While Not Recordset.EOF
Response.Write Recordset("MyRecord") & "<br>"
Recordset.MoveNext
Wend
%>

Grant
"Moragreid" <webforumsuser@macromedia.com> wrote in message
news:d3lj7f$hf$1@forums.macromedia.com...

> This may be really easy - but can anyone tell me how to create a record
> set to
> show all records except the first record.
> I would use the primary key ID but it may change with adding and deleting
> of
> records. So just to show all except the lowest ID
>
> any ideas?
>

[David Powers]

Moragreid wrote:

> This may be really easy - but can anyone tell me how to create a record set to
> show all records except the first record.

When asking for advice of this sort, you need to specify which database
you're working with, because the syntax is often different.

If you're using MySQL, put this at the end of your SELECT statement:

LIMIT 1,999999999999999999999

For example:

SELECT * FROM mytable
WHERE this = 'that'
ORDER BY primary_key
LIMIT 1,999999999999999999999

That will skip the first item. The 999999999999999999999 is an
arbritrarily high number to indicate that you want all records.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[Julian Roberts]

Something like

select * from t where in not in (
select id from t order by id
)
order by id

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004