<% '################################################################################# '## Copyright (C) 2000 Michael Anderson '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or any later version. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Correspondence and Questions can be sent to: '## reinhold@bigfoot.com '## '## or '## '## Snitz Communications '## C/O: Michael Anderson '## PO Box 200 '## Harpswell, ME 04079 '################################################################################# %>

Aller à: Choix Forum <% '## Get all Forum Categories From DB strSql = "SELECT " & strTablePrefix & "CATEGORY.CAT_ID, " & strTablePrefix & "CATEGORY.CAT_NAME " strSql = strSql & " FROM " & strTablePrefix & "CATEGORY" set rsCat = my_conn.Execute (strSql) do until rsCat.eof '## Grab the Categories. '## Build SQL to get forums via category '## Forum_SQL strSql = "SELECT " & strTablePrefix & "FORUM.FORUM_ID, " & strTablePrefix & "FORUM.F_TYPE, " & strTablePrefix & "FORUM.F_SUBJECT, " & strTablePrefix & "FORUM.F_URL, " & strTablePrefix & "FORUM.CAT_ID " strSql = strSql & " FROM " & strTablePrefix & "FORUM " strSql = strSql & " WHERE " & strTablePrefix & "FORUM.CAT_ID = " & rsCat("CAT_ID") strSql = strSql & " ORDER BY " & strTablePrefix & "FORUM.F_SUBJECT ASC;" set rsForum = my_Conn.Execute (StrSql) if rsForum.eof or rsForum.bof then 'nothing else iNewCat = rsForum("CAT_ID") iOldCat = 0 do until rsForum.Eof if ChkForumAccess(rsForum("FORUM_ID")) then if iNewCat <> iOldCat Then Response.Write " " & rsCat("CAT_NAME") & "" & vbCrLf iOldCat = iNewCat end if if rsForum("F_TYPE") = 0 then Response.Write "       " & rsForum("F_SUBJECT")& "" & vbCrLf end if rsForum.MoveNext loop end if rsCat.MoveNext loop %>  -------------------- Retour Sujets actifs FAQ Information Membre Chercher page