| Author |
 Topic  |
|
|
fredy
Starting Member
Switzerland
33 Posts |
 Posted - 09 August 2005 : 15:43:00
|
Hi
I do have different locked members.
It is strange, that when I click on "Members" the locked ones are not shown, but if I click on a Letter in the Members Site, I can see the locked members.
Is there a solution ?
Thanks & best regards
Fredy |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 10 August 2005 : 04:44:27
|
Find the following on line 127 of members.asp and add the code in green:if srchInitial = "1" then
tmpSQL = "M_NAME LIKE '" & SearchName & "%'"
end if
whereSql = whereSql & tmpSql &")"
if mlev = 4 then
whereSql = whereSql & " WHERE M_NAME <> 'n/a' "
else
whereSql = whereSql & " WHERE M_STATUS = " & 1
end if Although, I do seem to recall a discussion about this a while back that explained the logic of doing it the way it is done.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
 |
|
|
fredy
Starting Member
Switzerland
33 Posts |
Posted - 11 August 2005 : 13:57:44
|
Thanks, but now I get this error:
Microsoft JET Database Engine Fehler "80040e14'
Syntaxfehler (fehlender Operator) in Abfrageausdruck '(M_NAME LIKE 'B%') WHERE M_NAME <> 'n/a''.
/members.asp, line 234
Here the Code I changed:
whereSql = whereSql & tmpSql &")"
if mlev = 4 then
whereSql = whereSql & " WHERE M_NAME <> 'n/a' "
else
whereSql = whereSql & " WHERE M_STATUS = " & 1
end if
Session(strCookieURL & "where_Sql") = whereSql
In Line 234 I do have this code:
rs.open strSql & strSql2 & strSql3 & strSql4, my_Conn, adOpenStatic
Thanks
Fredy |
Edited by - fredy on 11 August 2005 14:01:22 |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 11 August 2005 : 13:59:56
|
Oop! Sorry  Change the two occurences of WHERE in the code I posted in green above to AND.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
fredy
Starting Member
Switzerland
33 Posts |
Posted - 11 August 2005 : 14:03:31
|
OK.
But now I do have the locked Members showing up again.
Here is, how the code looks now:
if mlev = 4 then
whereSql = whereSql & " AND M_NAME <> 'n/a' "
else
whereSql = whereSql & " AND M_STATUS = " & 1
end if
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 12 August 2005 : 04:58:45
|
Yes, as admin you will be able to view the locked members when viewing the full list and individual letters, should you ever need to unlock them. All other members, however, inclucing moderators, will not see the locked members at all.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
fredy
Starting Member
Switzerland
33 Posts |
Posted - 12 August 2005 : 15:08:46
|
oops...that I forgot.
It works !!! 
Thank you very much ! |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 15 August 2005 : 05:06:04
|
You're welcome
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
| |
Topic |
|
Topic Locked
