Home  »  Forum  »  ASP.Net  »

how to rectify repeated values in page?

 Posted By : chandru MPosted Date : 21/07/2011 12:51:43 PM Category : ASP.Net Points : 1

Dear all,

  am using forum forms. posted in any matters and response for another user. my forum go to top list. again user post in response.now only display two time. this is my problem.

am using this query

sqlquery = "select DISTINCT F.forumID,F.Author,F.forumTitle,F.forumDesc,F.Category,F.Points,F.Images,F.Status,F.Dateofpost,Convert(VARCHAR(10),F.Dateofpost,101) as Jdate,s.Dateofpost from tblForum F inner join tblForumResponse s on F.forumID=s.forumID where F.Status='Approved' order by s.Dateofpost desc";

Advance Thanks

Responses
 Author : Manoranjan Sahoo Member Level : BronzeDate : 21/07/2011 01:04:40 PM Points : 1

can you please clear your exact problem?

because i am not getting your point.

please explain clearly...

Thank You.



 Author : chandru M Member Level : BronzeDate : 21/07/2011 01:24:58 PM Points : 1

hi,

am post in any one title. this title response another person nwo title is top of the list. again another person response this title. now  display in two times. i want this post how many time response.Title  display in one time only in this page. hwo?

am using query already send it



 Author : Manoranjan Sahoo Member Level : BronzeDate : 21/07/2011 01:35:05 PM Points : 1

hi,

can you give one example?

actually i am not getting your point clearly. So please  explain with example.

Thank You.



 Author : chandru M Member Level : BronzeDate : 21/07/2011 01:40:47 PM Points : 1

like dotnetquare.com forum post and response..



 Author : Manoranjan Sahoo Member Level : BronzeDate : 21/07/2011 01:53:33 PM Points : 1

no, i want to know the error with example.

please explain the problem or error with an example.



 Author : chandru M Member Level : BronzeDate : 21/07/2011 03:42:48 PM Points : 0

hi

any reponse for the post   repeated display forums



 Author : Manoranjan Sahoo Member Level : BronzeDate : 14/10/2011 06:05:56 AM Points : 1

can you please tell me all the field of your forum table and response table? So that i can make one query to fetch all the data as per your requirement.

Thank You.



Post Reply
Login to post Response.