Snitz Forums 2000 - Pop-up Topic Statistics 1.5

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Pop-up Topic Statistics 1.5

New Topic

Topic Locked

Printer Friendly

Author

Topic

jensen
New Member

United Kingdom
97 Posts

Posted - 11 January 2005 : 10:06:36

Just got this error message in the popup (reads), the replied popup is OK

>>>>
Microsoft JET Database Engine error '80004005'
Query is too complex.

/pop_topic_stats.asp, line 113
>>>>>>

Stats on topis reply = 11, read = 1151

The forum and database are presently behind a firewall on an intranet.

Cheers

This is the only topic with this error, all others are OK

Edited by - jensen on 11 January 2005 10:09:51

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 11 January 2005 : 12:18:59

Line 101, add the code in ~~green~~ and see if that helps... Please note to look over the code carefully, my eyes arent cooperating with me.


		  if i=0 then
		    strsql = strsql & " WHERE M.MEMBER_ID=" & Cint(tMemArray(i))
		  else
		    strsql = strsql & " OR M.MEMBER_ID=" & Cint(tMemArray(i))
		  end if

Make it look like this


		  if i=0 then
		    strsql = strsql & " WHERE M.MEMBER_ID=" & Cint(tMemArray(i))
		  else
                    if Not(Instr(strsql, "M.MEMBER_ID=" & Cint(tMemArray(i))) then
		      strsql = strsql & " OR M.MEMBER_ID=" & Cint(tMemArray(i))
                    end if
		  end if

-Stim

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 17 January 2005 : 13:16:36

did that work for you?

-Stim

jensen
New Member

United Kingdom
97 Posts

Posted - 03 February 2005 : 07:06:24

Unfortunately no

this line
if Not(Instr(strsql, "M.MEMBER_ID=" & Cint(tMemArray(i))) then

needs to be
if Not(Instr(strsql, "M.MEMBER_ID=" & Cint(tMemArray(i)))) then

but i still get the error
Microsoft JET Database Engine error '80004005'

Query is too complex.

/pop_topic_stats.asp, line 121
I can mail you a txt file of the query - its a little large to post.

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 03 February 2005 : 07:08:12

Can you post a *.txt copy of the file?

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.”

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 03 February 2005 : 16:14:14

and a response.write on the query too if possible.

-Stim

jensen
New Member

United Kingdom
97 Posts

Posted - 04 February 2005 : 07:00:31

the response.write output of the query...

SELECT M.M_NAME, M.MEMBER_ID FROM FORUM_MEMBERS M WHERE M.MEMBER_ID=2 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=39 OR M.MEMBER_ID=45 OR M.MEMBER_ID=13 OR M.MEMBER_ID=13 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=24 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=85 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=30 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=97 OR M.MEMBER_ID=97 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=13 OR M.MEMBER_ID=4 OR M.MEMBER_ID=4 OR M.MEMBER_ID=4 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=4 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=4 OR M.MEMBER_ID=4 OR M.MEMBER_ID=4 OR M.MEMBER_ID=4 OR M.MEMBER_ID=1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=61 OR M.MEMBER_ID=61 OR M.MEMBER_ID=21 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=24 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=13 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=24 OR M.MEMBER_ID=24 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=97 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=61 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=85 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=24 OR M.MEMBER_ID=24 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=28 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=39 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=96 OR M.MEMBER_ID=96 OR M.MEMBER_ID=96 OR M.MEMBER_ID=96 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=13 OR M.MEMBER_ID=13 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=85 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=30 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=97 OR M.MEMBER_ID=97 OR M.MEMBER_ID=97 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=96 OR M.MEMBER_ID=96 OR M.MEMBER_ID=96 OR M.MEMBER_ID=96 OR M.MEMBER_ID=96 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=35 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=45 OR M.MEMBER_ID=45 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=18 OR M.MEMBER_ID=18 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=45 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=30 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=45 OR M.MEMBER_ID=45 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=24 OR M.MEMBER_ID=24 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=13 OR M.MEMBER_ID=18 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=30 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=107 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=97 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=45 OR M.MEMBER_ID=97 OR M.MEMBER_ID=97 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=97 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=4 OR M.MEMBER_ID=4 OR M.MEMBER_ID=97 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=13 OR M.MEMBER_ID=13 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=2 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=18 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=27 OR M.MEMBER_ID=27 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=4 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=66 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=45 OR M.MEMBER_ID=30 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=13 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=24 OR M.MEMBER_ID=24 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=2 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=97 OR M.MEMBER_ID=97 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=24 OR M.MEMBER_ID=24 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=13 OR M.MEMBER_ID=13 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=97 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=30 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=13 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=2 OR M.MEMBER_ID=66 OR M.MEMBER_ID=4 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=24 OR M.MEMBER_ID=24 OR M.MEMBER_ID=24 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=13 OR M.MEMBER_ID=13 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=97 OR M.MEMBER_ID=97 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=30 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=39 OR M.MEMBER_ID=39 OR M.MEMBER_ID=39 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=39 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=39 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=97 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=4 OR M.MEMBER_ID=4 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=66 OR M.MEMBER_ID=66 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=97 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=34 OR M.MEMBER_ID=34 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=2 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=24 OR M.MEMBER_ID=24 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=30 OR M.MEMBER_ID=39 OR M.MEMBER_ID=13 OR M.MEMBER_ID=13 OR M.MEMBER_ID=39 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=97 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 OR M.MEMBER_ID=-1 ORDER BY M_NAME ASC

Stats = 14 replys 1538 reads

error = Microsoft JET Database Engine error '80004005'
Query is too complex.

/pop_topic_stats.asp, line 121

Edited by - jensen on 04 February 2005 07:05:12

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 04 February 2005 : 07:07:57

Holy hell!

That is complex; can you post a *.txt copy of the file so's we can have a look at cleaning it up for you?

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.”

jensen
New Member

United Kingdom
97 Posts

Posted - 07 February 2005 : 07:55:03

I guess you need the pop_topic_stats.asp file from the mod

I am at work and the firwall will not allow me to FTP, but the file is that from the mod availalable here : http://forum.snitz.com/forum/topic.asp?TOPIC_ID=55687

The only change i have made is that as descriobed above

' ##### Mod from forum ############
' if i=0 then
' strsql = strsql & " WHERE M.MEMBER_ID=" & Cint(tMemArray(i))
' else
' strsql = strsql & " OR M.MEMBER_ID=" & Cint(tMemArray(i))
' end if
if i=0 then
strsql = strsql & " WHERE M.MEMBER_ID=" & Cint(tMemArray(i))
else
if Not(Instr(strsql, "M.MEMBER_ID=" & Cint(tMemArray(i)))) then
strsql = strsql & " OR M.MEMBER_ID=" & Cint(tMemArray(i))
end if
' ##### End Mod from forum ############

Edited by - jensen on 07 February 2005 07:55:47

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 07 February 2005 : 08:28:03

Try replacing that entire block of code with the following (you'll need to declare a variable called strMembers before your for/next loop:

if instr(","&strMembers&",",","&clng(tMemArray(i))&",")=0 and clng(tMemArray(i))>0 then
if len(strMembers)>0 then strMembers=strMembers&","
strMembers=strMembers&clng(tMemArray(i))
end if

Then, after the for/next loop add the following line:

strSql=strSql&" WHERE M.MEMBER_ID IN ("&strMembers&")"

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.”

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 07 February 2005 : 14:53:24

... what shaggy said

-Stim

jensen
New Member

United Kingdom
97 Posts

Posted - 08 February 2005 : 04:46:11


' ##### Mod from forum ############
dim strMembers		
For i=0 to Cint(Ubound(tMemArray))
	if instr(","&strMembers&",",","&clng(tMemArray(i))&",")=0 and clng(tMemArray(i))>0 then
	if len(strMembers)>0 then strMembers=strMembers&","
		strMembers=strMembers&clng(tMemArray(i))
	end if
Next
strSql=strSql&" WHERE M.MEMBER_ID IN ("&strMembers&")"
' ##### End Mod from forum ############

You guys are just too dam clever !

Cheers

Edited by - jensen on 08 February 2005 04:48:33

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 08 February 2005 : 05:33:33

You're welcome, Jensen.

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

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.33 seconds.