The problem is with the querystriing. I have the one below but the problem is that it pulls the right ForumName and ForumDesc but the rest are filled in. What I mean is that only one forum(first one) is populated witha thread row. The rest are empty but
for some reason it is taking the one thread populated and filling the forum rows with it. There shouldnt be anything in the ThreadName for the rest of the rows except for the first one.
SELECT Fm.ForumName, Fm.ForumDesc, Td.ThreadName, Td.UserId, Pt.PostTime FROM Menu Mn, Forum Fm, Thread Td, Post Pt,aspnet_Users Us WHERE Mn.MenuId = Fm.MenuId AND Td.ThreadId = Pt.ThreadId AND Pt.UserId = Us.UserId AND Mn.MenuName = @Forum OR Td.ThreadTime = @dete
Code_warrior...
Member
251 Points
282 Posts
Re: Query problem - returns no details.
Apr 16, 2012 06:32 AM|LINK
The problem is with the querystriing. I have the one below but the problem is that it pulls the right ForumName and ForumDesc but the rest are filled in. What I mean is that only one forum(first one) is populated witha thread row. The rest are empty but for some reason it is taking the one thread populated and filling the forum rows with it. There shouldnt be anything in the ThreadName for the rest of the rows except for the first one.