database - show all records apart from the 1st...how?

[Nathon Jones]

Hi,

We have an events calendar in Access, and we are using VBScript/ASP for the
site.

Is it possible to display ALL events, apart from the 1st record?

We have a "latest news" section on a page, which displays the very latest
event (1st record in the database table). Below that we want to drop in a
repeat region for "other events" that would display everything,
chronologically, apart from the 1st record which is already displayed in
"latest news".

Thanks
Nath.

[BigJon1999]

In PHP i do it like this... ( for you, you need the ASP equiv of 'data_seek' )
# Get All Info $qAll='SELECT * FROM table WHERE bla bla';
$rAll=mysql_query($qAll,$conDB) or die(mysql_error().'-getAll-');
$numAll=mysql_num_rows($rAll); # if ($numAll>0): mysql_data_seek($rAll,
0); --- this line for all, or ',1' to skip first while
($rowAll=mysql_fetch_assoc($rAll)): echo $rowAll['fieldname'];
endwhile; endif; # This data_seek is real useful, as i can use the same DB
result set many times on the same page... Hope this helps.

[CMBergin]

Get all your results in a single recordset.
Display the latest record. Below the latest record, add
yourRSName.MoveNext().
Use a normal repeat region set to display all records in the area you'd like
to show other events.

"Nathon Jones" <nathonjonesNOT@kirkmoor.com> wrote in message
news:d047vp$1ef$1@forums.macromedia.com...

> Hi,
>
> We have an events calendar in Access, and we are using VBScript/ASP for

the

> site.
>
> Is it possible to display ALL events, apart from the 1st record?
>
> We have a "latest news" section on a page, which displays the very latest
> event (1st record in the database table). Below that we want to drop in a
> repeat region for "other events" that would display everything,
> chronologically, apart from the 1st record which is already displayed in
> "latest news".
>
> Thanks
> Nath.
>
>

[Julian Roberts]

Try

select * from news
where id not in (
select top 1 id from news order by id
)

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

[Nathon Jones]

Hi CM,

Sorry, but can you talk me through that in a little more detail?

So, I create one recordset, that displays all the events, arranged by date
desc, so that the latest record, is 1st.

How do I then add Recordset.MoveNext?

For my sakes (!), lets say I have two fields showing. This is how it would
appear in my code (within a standard repeat region)...

<%=(rsEvents.Fields.Item("eventname").Value)%><b r>
<%=(rsEvents.Fields.Item("eventdate").Value)%>

So where am I adding - rsEvents.MoveNext()?

Thanks again.
Nath.

"CMBergin" <NoHarvestForYou@NoSpam.org> wrote in message
news:d04erv$c1i$1@forums.macromedia.com...

> Get all your results in a single recordset.
> Display the latest record. Below the latest record, add
> yourRSName.MoveNext().
> Use a normal repeat region set to display all records in the area you'd
> like
> to show other events.
>
> "Nathon Jones" <nathonjonesNOT@kirkmoor.com> wrote in message
> news:d047vp$1ef$1@forums.macromedia.com...

>> Hi,
>>
>> We have an events calendar in Access, and we are using VBScript/ASP for

> the

>> site.
>>
>> Is it possible to display ALL events, apart from the 1st record?
>>
>> We have a "latest news" section on a page, which displays the very latest
>> event (1st record in the database table). Below that we want to drop in
>> a
>> repeat region for "other events" that would display everything,
>> chronologically, apart from the 1st record which is already displayed in
>> "latest news".
>>
>> Thanks
>> Nath.
>>
>>

>
>