Hi,

I am on the process of building a events page, where through 3 access levels (admin, author and Member) can modify, post and view some pages of the site respectively. MY problem is the following:

A member belongs to a State as well as a Local organization. The State Level info is Public, but the local info need login. When the member logs in, he/she is redirected to the members page, that should display only information pertinent to their Local organization. How can I do that? I have tried using UserID, MM_Username, but I don't seem to be able to get it.


The following is where I'm at:
<%
Dim rscChapterDisplay__MMColParam
rscChapterDisplay__MMColParam = "1"
If (Session("MM_ChapterID" <> "" Then
rscChapterDisplay__MMColParam = Session("MM_ChapterID"
End If
%>
<%
Dim rscChapterDisplay
Dim rscChapterDisplay_numRows

Set rscChapterDisplay = Server.CreateObject("ADODB.Recordset"
rscChapterDisplay.ActiveConnection = MM_connCMS_STRING
rscChapterDisplay.Source = "SELECT dteEventDate, intChapID, intPostID, memPostContent, txtEventTitle, txtFileName, txtImageName FROM tblPosts WHERE intChapID = " + Replace(rscChapterDisplay__MMColParam, "'", "''" + " ORDER BY dteEventDate DESC"
rscChapterDisplay.CursorType = 0
rscChapterDisplay.CursorLocation = 2
rscChapterDisplay.LockType = 1
rscChapterDisplay.Open()

rscChapterDisplay_numRows = 0
%>

help,

Javier