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
 Other Forums
 Other Topics
 Forum Feature?

Author  Topic 

MichaelP
Jedi Yak

2489 Posts

Posted - 2002-05-21 : 13:48:10
Hey Graz,
Is there any way you could setup something that allows a user to mark a posted question as "finished / solved" so that we can filter those out? I like the "Active Topics" page, but I'd like a way to confiure what that page displays, either all active topics, or active UNSOLVED topics. I can't tell you how many posts I've opened up to answer, only to find that a solution has been found. I would think I'm not the only person to run into this. I'm guessing it would definatly lessen the load on yours servers, but it might slow yer SQL server down a bit. It would lower your page views, so it would probably impact yoru ad revenues too :(

Anyway, just a thought.

Michael

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-05-21 : 15:06:23
If this feature existed, I personally would probably ignore it. I have seen several situations where the question appeared to be solved, and the original asker probably would have thought it was solved, but there was a subtle nuance missing or maybe just a different (possibly better) way to solve the problem. I'd hate for people to be discouraged from posting because they thought the question was "solved". I enjoy reading the questions and seeing if there is any additional insight I can provide.

Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2002-05-21 : 15:18:25
Hmm good point, but that's why I suggested it be optional.
Let those who want to see all, see all. let those who don't, dont'.

As far as the marking....let the user who posted the question to mark it as answered. I'm not sure if I was clear about that.

If the user feels they have a solution that's good enough, they could mark it. If they want more feedback, they can leave it unmarked.

How does that sound?

Michael

Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-05-21 : 15:34:52
That's something that's been requested a couple of times. I'm not opposed to it -- especially if it's optional. I am opposed to the level of effort required to make it work :) I've downloaded these forums and modified them as little as possible. There is just a mess o'ASP code behind here that I'm not every excited to wade through. There are new versions of the forum coming out "any day now". After they are released I may look at it. I'm also considering writing my own forums or moving away from Snitz to something that would be more suitable to this site. Thanks for the feedback and I'll keep it in mind but I wouldn't hold your breath.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

joldham
Wiseass Yak Posting Master

300 Posts

Posted - 2002-05-21 : 17:04:23
graz,

If you do decide to 'write your own' forum, will you use ASP or ASP.NET? Also, it might be a nice community project for SQLTeamers to participate and help develop, saving you some time and effort. I would be willing to contribute (for what that's worth ).

Just a thought.

Jeremy

Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2002-05-21 : 17:14:20
Same here, although maintainign code written by a bunch fo people who all have different styles could be tough.

Michael

Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-05-21 : 17:28:55
quote:
If you do decide to 'write your own' forum, will you use ASP or ASP.NET? Also, it might be a nice community project for SQLTeamers to participate and help develop, saving you some time and effort. I would be willing to contribute (for what that's worth ).

I've been toying with a rewrite of the SQLTeam engine in .NET for a while. The forums are a key part of that providing user authentication. Unfortunately it's not possible to share session information between ASP and .NET so a partial rewrite isn't really feasible. I have rewritten some of the admin pages in .NET and I've been very happy with it.

I'm not sure about involving other people. I don't have any shortage of volunteers at this point :) In times past I've tried to sell the publishing engine behind SQLTeam. Unfortunately that never went anywhere. If I involve SQLTeam readers I probably wouldn't be able to sell the code but I'm not sure that's high on the priority list.

If I wrote my own I'd probably write the base system and then ask people to add features within that framework. That seems like the easiest way to do it. That would also allow me to add features like the one that started this thread. I think the performance of the forums would be much improved also.

I'm kind of hoping that with .NET I'll find some code released that does close to what I want. I'd much rather buy (or just download) than build.

Right now everything works well enough that I'm not feeling any "pain" that needs to be resolved. Therefore I'm not in any rush to jump in and make changes. I'll certainly keep these offers in mind though as I figure out what to do.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2002-05-21 : 17:40:58
Maybe you could post a sample database, and folks would write an ASP.Net frontend to it? Then you could pick and choose which set of code to go with.

Michael

Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-05-21 : 18:43:09
A totally different type of Reader's Challenge. But this time, don't have Rob do the judging.

Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2002-05-21 : 19:22:53
Now, there's an idea!
Everyone submit their ASP, and then allow folks to vote on which one they like!
A reader's challenge and a Poll all in one!

...is that triple word score or something??

Michael

Go to Top of Page

joldham
Wiseass Yak Posting Master

300 Posts

Posted - 2002-05-21 : 23:20:54
I think a Reader Challenge before that should be the following:

Write a SQL script that will take all the submission for the "Find the " Reader Challenge and judge them according to whichever criteria makes yours the winner.

Winner will save Rob the time and SQLTeam jabs and a copy of "The Guru's Guide to Transact-SQL ".

Jeremy

Go to Top of Page
   

- Advertisement -