Memo snippet

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

Aaron
Thu Oct 30 16:25:15 CST 2003

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...
> 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
>
>

Mike
Thu Oct 30 16:39:37 CST 2003


"Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
news:O6Ao1SznDHA.1740@TK2MSFTNGP12.phx.gbl...
> 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...
> > 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
> >
> >
>
> Cheers