Discussion forums

[agustr]

I would like to make a discussion forum in asp and wondered if it there did not exist something that I could base my amature work on or simply get another readymade?

[Johnny101]

www.asp101.com has an ASP based forum and they offer source code. It's pretty cool. I wrote my own so I could get the experience and I recommend it to you as well. Even if you don't use the one you wrote in "production", you can learn a lot. I downloaded the source code for ASP101's forums and that gave me some ideas. Then I combined those ideas with others i had. I was a great learning experience. Mine is at www.stlvbug.org/newsgroup.asp - if you want to see it.

hope this helps,

John

John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org

[agustr]

My knowledge of the English language is not able to fully express my thankfullness.
So you see I am greatfull!!

[Rick Leinecker]

You can also go to www.wwwthreads.com. They offer a full-featured forum package for $200.

It's unix-based, but can be easily adapted for NT/W2K.

[dmeikle]

one simple way of doing it is to recursively call the subroutine:

private sub DrawThreads(intParentID,intIndent)
dim rsQuery
set rsQuery=server.createobject("adodb.recordset")

'define your dbConnection wherever, however...
strQuery="select * from table where parentid=" & intParentID
rsQuery.open strQuery, dbConnect, adopenforwardonly, adlockreadonly
do while not rsQuery.eof
response.write string(".",5)' indents the link
response.write '(place your dyanmically drawn link here)eg.title, name, date....
'search for any child threads
call DrawThreads(rsQuery("threadid"), intIndent+5
rsQuery.movenext
loop
rsQuery.close
set rsQuery=nothing
end sub

This is just a simple example if how to write a makeshift version... but it gives an idea :)

David