Most recent posts?

Author	Message

willmasters

Total Posts : 8
Reward points : 0
Joined: Nov 09 '01
Status: offline

Most recent posts? Mon. Dec 17, '01 3:58 AM (permalink)

0

Could you tell me how to display all posts made by a user in their profile - instead of just the last 5?

is it something to do with: (arrMemPosts,2)

The reason I ask is because we are doing a project and we have to see all the posts made by a student quickly and easily for assessment purposes. Any help on this one would be greatly appreciated.

Thanks,

Will.

#1

Samuel

Total Posts : 11786
Reward points : 168350
Joined: May 23 '01
Status: offline

RE:Most recent posts? Mon. Dec 17, '01 4:17 AM (permalink)

0

Hi,

Open up your Access db first. Locate the " Queries" tab on the left (the default is " Tables" ), click on it and find a query called " spShowProfile2" . Right click on " spShowProfile2" and select " Design View" .

It looks like the following:

 PARAMETERS show_Mem Long;
 SELECT [color=blue][b]TOP 5[/b][/color] messageID, subject, dateCreated, forumID
 FROM Messages
 WHERE Mem=[show_Mem]
 ORDER BY messageID DESC;

All you have to do now is to delete the highlighted part in the above query. Save the db and you are set. It is as simple as that.

have a good day ^ ^

_____________________________

< Message edited by Admin on 12/17/2001 4:18:55 AM >

#2

willmasters Total Posts : 8 Reward points : 0 Joined: Nov 09 '01 Status: offline	RE:RE:Most recent posts? Mon. Dec 17, '01 4:18 AM (permalink) 0 Thanks a million Samuel. Will.
	#3

Guest

RE:Most recent posts? Mon. Dec 17, '01 11:16 AM (permalink)

0

ORIGINAL : willmasters

Could you tell me how to display all posts made by a user in their profile - instead of just the last 5?

is it something to do with: (arrMemPosts,2)

The reason I ask is because we are doing a project and we have to see all the posts made by a student quickly and easily for assessment purposes. Any help on this one would be greatly appreciated.

Thanks,

Will.