| Author |
 Topic Search  Topic Options
|
felix.akinyemi 
Groupie
Joined: 09 December 2004
Location: United States
Status: Offline
Points: 113
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 21 July 2005 at 12:37pm |
Yeah, had to make a few changes but it still getting the same error im
getting... the error is that is displays all the groups and all the
authors multi times instead of only the author and groups for the specific forum!!
This is the initial code i tried it with as well but no luck!! 
strSQL = "SELECT " & strDbTable & "Author.Author_ID, " &
strDbTable & "Author.Username, " & strDbTable &
"Group.Group_ID, " & strDbTable & "Group.Name "
strSQL = strSQL & "FROM " & strDbTable & "Author, " &
strDbTable & "Group, " & strDbTable & "Permissions "
strSQL = strSQL & "WHERE ((" & strDbTable & "Group.Group_ID
= " & strDbTable & "Permissions.Group_ID) OR (" &
strDbTable & "Author.Author_ID = " & strDbTable &
"Permissions.Author_ID)) AND " & strDbTable &
"Permissions.Moderate = " & blnSQLBool & " AND " &
strDbTable & "Permissions.Forum_ID = " & intForumID & ";"
|
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 July 2005 at 2:08pm |
|
not sure on this now.
have you a link to the page that shows your out put, and with the query
you are using now. did you try mine, as i think that should have worked.
|
|
felix.akinyemi
Groupie
Joined: 09 December 2004
Location: United States
Status: Offline
Points: 113
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 July 2005 at 5:43am |
The site are:
My Query - Your Query but its ment to look like this This
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 July 2005 at 7:18am |
|
is default 3 a staic page or using a query, coz you could copy and paste that.
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 July 2005 at 7:21am |
|
right looking at what you want.
you dont want to show the users within that groupo.
what you show in default 3 is what is within the default WWF Version i belive
|
|
felix.akinyemi
Groupie
Joined: 09 December 2004
Location: United States
Status: Offline
Points: 113
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 July 2005 at 7:12pm |
|
default3.asp is the one built in WWF, but i need to get them in one
query to lessen DB calls cuz i need to add it to an external forum page
which already has enough DB calls!!
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 July 2005 at 7:23pm |
try this
strSQL = "SELECT " & strDbTable & "Author.Author_ID, " &
strDbTable & "Author.Username, " & strDbTable &
"Group.Group_ID, " & strDbTable & "Group.Name "
strSQL = strSQL & "FROM " & strDbTable & "Author, " &
strDbTable & "Group, " & strDbTable & "Permissions "
strSQL = strSQL & "WHERE ((" & strDbTable & "Group.Group_ID
= " & strDbTable & "Permissions.Group_ID) OR (" &
strDbTable & "Author.Author_ID = " & strDbTable &
"Permissions.Author_ID AND NOT (" & strDbTable &
"Permssions.Group_ID = " & strDbTable &"Author_Group_ID AND " & strDbTable &
"Permssions.Moderate = True)) AND " & strDbTable &
"Permissions.Moderate = " & blnSQLBool & " AND " &
strDbTable & "Permissions.Forum_ID = " & intForumID & ";"
thats a weild guess
|
|
felix.akinyemi
Groupie
Joined: 09 December 2004
Location: United States
Status: Offline
Points: 113
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 July 2005 at 7:43pm |
Somethings wrong Click Here
|
|
