Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Displaying edited articles by latest edited date

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-13 : 00:28:47
David writes "I need to display edited stories by there storythread number and there last edited date. I have selected a single story using the folowing sql.

sql="SELECT * " & _
"FROM News WHERE DateModified = (SELECT MAX(DateModified) FROM News WHERE StoryThread = " & StoryThread & ")"

But I now need to display a number of the latest articles on the same page. Could anyone offer any suggestions on how to do this.

Thanks in advance."
   

- Advertisement -