470,594 Members | 1,407 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,594 developers. It's quick & easy.

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
Jul 19 '05 #1
2 1362
Last 5: use TOP 5 order by DateUpdated_column DESC

Extract: http://www.aspfaq.com/2398
"Mike M" <mi**@mack1.karoo.co.uk> wrote in message
news:bn**********@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

Jul 19 '05 #2

"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message
news:O6**************@TK2MSFTNGP12.phx.gbl...
Last 5: use TOP 5 order by DateUpdated_column DESC

Extract: http://www.aspfaq.com/2398
"Mike M" <mi**@mack1.karoo.co.uk> wrote in message
news:bn**********@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

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by jacoballen | last post: by
4 posts views Thread by Mark Reed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.