Web Wiz Support and Community Forums : Query Question https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 15:20:11 +0000 Fri, 22 Jul 2005 20:04:10 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=15925 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Query Question : U know what, you can leave it...]]> https://forums.webwiz.net/query-question_topic15925_post87541.html#87541 Author: felix.akinyemi
Subject: 15925
Posted: 22 July 2005 at 8:04pm

U know what, you can leave it out, no worries, ill find a way, thanks anyway!!]]> Fri, 22 Jul 2005 20:04:10 +0000 https://forums.webwiz.net/query-question_topic15925_post87541.html#87541 <![CDATA[Query Question : Somethings wrong Click Here ]]> https://forums.webwiz.net/query-question_topic15925_post87540.html#87540 Author: felix.akinyemi
Subject: 15925
Posted: 22 July 2005 at 7:43pm

Somethings wrong Click Here]]> Fri, 22 Jul 2005 19:43:23 +0000 https://forums.webwiz.net/query-question_topic15925_post87540.html#87540 <![CDATA[Query Question : try this strSQL = &#034;SELECT...]]> https://forums.webwiz.net/query-question_topic15925_post87538.html#87538 Author: dj air
Subject: 15925
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
]]> Fri, 22 Jul 2005 19:23:27 +0000 https://forums.webwiz.net/query-question_topic15925_post87538.html#87538 <![CDATA[Query Question : default3.asp is the one built...]]> https://forums.webwiz.net/query-question_topic15925_post87537.html#87537 Author: felix.akinyemi
Subject: 15925
Posted: 22 July 2005 at 7:12pm

default3.asp is the one built in WWF, but i need to get them in onequery to lessen DB calls cuz i need to add it to an external forum pagewhich already has enough DB calls!!
]]> Fri, 22 Jul 2005 19:12:14 +0000 https://forums.webwiz.net/query-question_topic15925_post87537.html#87537 <![CDATA[Query Question : right looking at what you want. you...]]> https://forums.webwiz.net/query-question_topic15925_post87483.html#87483 Author: dj air
Subject: 15925
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
]]> Fri, 22 Jul 2005 07:21:04 +0000 https://forums.webwiz.net/query-question_topic15925_post87483.html#87483 <![CDATA[Query Question : is default 3 a staic page or using...]]> https://forums.webwiz.net/query-question_topic15925_post87482.html#87482 Author: dj air
Subject: 15925
Posted: 22 July 2005 at 7:18am

is default 3 a staic page or using a query, coz you could copy and paste that.]]> Fri, 22 Jul 2005 07:18:40 +0000 https://forums.webwiz.net/query-question_topic15925_post87482.html#87482 <![CDATA[Query Question : The site are: My Query - Your...]]> https://forums.webwiz.net/query-question_topic15925_post87479.html#87479 Author: felix.akinyemi
Subject: 15925
Posted: 22 July 2005 at 5:43am

The site are:

My Query - Your Query but its ment to look like this This]]> Fri, 22 Jul 2005 05:43:47 +0000 https://forums.webwiz.net/query-question_topic15925_post87479.html#87479 <![CDATA[Query Question : not sure on this now. have...]]> https://forums.webwiz.net/query-question_topic15925_post87435.html#87435 Author: dj air
Subject: 15925
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 queryyou are using now. did you try mine, as i think that should have worked.
]]> Thu, 21 Jul 2005 14:08:52 +0000 https://forums.webwiz.net/query-question_topic15925_post87435.html#87435 <![CDATA[Query Question : Yeah, had to make a few changes...]]> https://forums.webwiz.net/query-question_topic15925_post87425.html#87425 Author: felix.akinyemi
Subject: 15925
Posted: 21 July 2005 at 12:37pm

Yeah, had to make a few changes but it still getting the same error imgetting... the error is that is displays all the groups and all theauthors 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!! Confused


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 & ";"


]]> Thu, 21 Jul 2005 12:37:42 +0000 https://forums.webwiz.net/query-question_topic15925_post87425.html#87425 <![CDATA[Query Question : strSQL = &#034;SELECT &#034; &amp;...]]> https://forums.webwiz.net/query-question_topic15925_post87417.html#87417 Author: dj air
Subject: 15925
Posted: 21 July 2005 at 11:40am

strSQL = "SELECT " & strDbTable & "Group.Group_ID, " & strDbTable & "Group.Name, " & strDbTable & "Author.Author_ID, " & strDbTable & "Author.Username "
strSQL = strSQL & "FROM " & strDbTable & "Permissions, " & strDbTable & "Group, " & strDbTable & "Author "
strSQL = strSQL & "WHERE " & strDbTable & "Author.Author_ID
= " & strDbTable & "Permissions.Author_ID AND " &
strDbTable & "Permissions.Moderate = True AND " & strDbTable
& "Permissions.Forum_ID = " & intForumID & " AND " & strDbTable & "Group.Group_ID = " & strDbTable & "Author.Author_ID ORDER BY " & strDbTable & "Author.Username;"

dim blnFirst
dim intMODGroupID
blnFirst = True
then you need ot do a check
do while NOT rsCommon.eof
intMODGroupID = rsCommon("Group_ID")

if rsCommon("Group_ID") <> intMODGroupID OR blnFirst= True then

strModeratorsList = "<a href=""members.asp?GID=" & rsCommon("Group_ID") & """>" & rsCommon("Group_name") & "</a> :"
blnFirst = False
END IF 

        strModeratorsList =
strModeratorsList & " <a
href=""JavaScript:openWin('pop_up_profile.asp?PF=" &
rsCommon("Author_ID")  &
"','profile','toolbar=0,location=0,status=0,menubar=0,scrollbars=1,resizable=1,width=590,heig ht=425')""
class=""smLink"">" & rsCommon("Username") & "</a>"

rsCommon.movenext

loop


of course you need to do a check before thats done making sure there are records to prevent errors.

that will give a list like 

GroupName : username username Group Name : userame username


i aven't tested it in any way apart from in my head but should help
]]> Thu, 21 Jul 2005 11:40:09 +0000 https://forums.webwiz.net/query-question_topic15925_post87417.html#87417