Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Message Icons Mod - Problems....
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

xx ENIGMA xx
Junior Member

166 Posts

Posted - 02 December 2003 :  16:41:44  Show Profile  Send xx ENIGMA xx an AOL message
original mod topic > http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=34250

I have just installed this mod (my 2nd try ughh)
and it finally worked but now I have an error when checking
active topics as mentioned in the above thread.

I applied the fix that Hamlin mentioned of adding a comma (,)
after T.T_MSGICON like so: "T.T_MSGICON ," & _ which seems to
have helped that person but I still get the same error

the identical error I get:


Microsoft JET Database Engine error '80040e14' 

Syntax error (missing operator) in query expression 'F.F_PASSWORD_NEW T.T_MSGICON'. 

/bbs/active.asp, line 315 


text version of my active.asp if needed > active.txt

thanks for any help



my little forum playground


Edited by - xx ENIGMA xx on 02 December 2003 17:30:25

Rasco
Advanced Member

Germany
3192 Posts

Posted - 02 December 2003 :  17:51:24  Show Profile  Send Rasco an ICQ Message
I think, instead of

"F.F_PASSWORD_NEW " & _
"T.T_MSGICON, " & _

it should be

"F.F_PASSWORD_NEW, " & _
"T.T_MSGICON " & _


German Snitz Forum
Go to Top of Page

xx ENIGMA xx
Junior Member

166 Posts

Posted - 02 December 2003 :  18:15:15  Show Profile  Send xx ENIGMA xx an AOL message
quote:
Originally posted by Rasco

I think, instead of

"F.F_PASSWORD_NEW " & _
"T.T_MSGICON, " & _

it should be

"F.F_PASSWORD_NEW, " & _
"T.T_MSGICON " & _





I guess you didnt understand my original post above

I get the same error, same line number with comma (,)
or no comma. I just tried that fix since Hamlin suggested
it and it worked for someone else but not me.

anyone have any ideas please?



my little forum playground

Go to Top of Page

Rasco
Advanced Member

Germany
3192 Posts

Posted - 02 December 2003 :  18:28:33  Show Profile  Send Rasco an ICQ Message
I think I understand. In your active.asp after F.F_PASSWORD_NEW the , should be missing. With that done the , after T.T_MSGICON shouldn`t be necessary.
With Hamlins suggestion it worked since the order was another.

German Snitz Forum
Go to Top of Page

xx ENIGMA xx
Junior Member

166 Posts

Posted - 02 December 2003 :  18:40:49  Show Profile  Send xx ENIGMA xx an AOL message
ahhh I see what your saying now, I'll try that and post back

thanks for the idea...



my little forum playground

Go to Top of Page

xx ENIGMA xx
Junior Member

166 Posts

Posted - 02 December 2003 :  18:47:18  Show Profile  Send xx ENIGMA xx an AOL message
BINGO!

I made it look like this:
	 "F.F_PASSWORD_NEW, " & _
	 "T.T_MSGICON " & _


basically just switched the comma's (,) around and it fixed it

thanks so much Rasco, it's appreciated!



my little forum playground

Go to Top of Page

Rasco
Advanced Member

Germany
3192 Posts

Posted - 03 December 2003 :  03:21:34  Show Profile  Send Rasco an ICQ Message
You`re welcome

German Snitz Forum
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 1.25 seconds. Powered By: Snitz Forums 2000 Version 3.4.07