Hi all,

This is my first post here. I have been looking everywhere on the forums and
all over the net but i cannot find anything about this.

I did find one tutorial ages ago but didnt have a use for it at the time.
What i would like to do is have a page that cycles through a database and
display lets say the last 5 new records. Then display the first 200
characters of a memo field and have a "more" link which opens the full
record in a detail page?

A good example is http://www.ananova.com/ But you dont click a "more" link
just the title of the news article.

Any help will be greatly appreciated.
Many Thanks
Mike

Last 5: use TOP 5 order by DateUpdated_column DESC

Extract: http://www.aspfaq.com/2398


"Mike M" <mike@mack1.karoo.co.uk> wrote in message
news:bns1ug$iqb$1@newsreaderg1.core.theplanet.net. ..[color=blue]
> Hi all,
>
> This is my first post here. I have been looking everywhere on the forums[/color]
and[color=blue]
> all over the net but i cannot find anything about this.
>
> I did find one tutorial ages ago but didnt have a use for it at the time.
> What i would like to do is have a page that cycles through a database and
> display lets say the last 5 new records. Then display the first 200
> characters of a memo field and have a "more" link which opens the full
> record in a detail page?
>
> A good example is http://www.ananova.com/ But you dont click a "more" link
> just the title of the news article.
>
> Any help will be greatly appreciated.
> Many Thanks
> Mike
>
>[/color]

"Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
news:O6Ao1SznDHA.1740@TK2MSFTNGP12.phx.gbl...[color=blue]
> Last 5: use TOP 5 order by DateUpdated_column DESC
>
> Extract: http://www.aspfaq.com/2398
>
>
> "Mike M" <mike@mack1.karoo.co.uk> wrote in message
> news:bns1ug$iqb$1@newsreaderg1.core.theplanet.net. ..[color=green]
> > Hi all,
> >
> > This is my first post here. I have been looking everywhere on the forums[/color]
> and[color=green]
> > all over the net but i cannot find anything about this.
> >
> > I did find one tutorial ages ago but didnt have a use for it at the[/color][/color]
time.[color=blue][color=green]
> > What i would like to do is have a page that cycles through a database[/color][/color]
and[color=blue][color=green]
> > display lets say the last 5 new records. Then display the first 200
> > characters of a memo field and have a "more" link which opens the full
> > record in a detail page?
> >
> > A good example is http://www.ananova.com/ But you dont click a "more"[/color][/color]
link[color=blue][color=green]
> > just the title of the news article.
> >
> > Any help will be greatly appreciated.
> > Many Thanks
> > Mike
> >
> >[/color]
>
> Cheers[/color]