Snitz Forums 2000 - Searching members error

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Searching members error

New Topic

Topic Locked

Printer Friendly

Author

Topic

Beano_ie
Junior Member

Ireland
328 Posts

Posted - 28 April 2002 : 16:40:14

I've had a forum setup for about three weeks now and today i went to search the members for someone and I surprisingly got the following error:

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'FORUM_MEMBERS.M_STATE FORUM_MEMBERS.M_PMRECEIVE'.

/df2/members.asp, line 236

Everything else is working fine in the forum and i'm guesing that i'm missing some small little ' or something but i'm not familiar enough with ASP as yet.

You can open the members.asp text version at the following link:

http://www.droghedatowncentre.com/df2/members.txt

Thank you

Steve.

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 28 April 2002 : 16:47:55

you are missing a comma after M_STATE:

this:

	strMemberTablePrefix & "MEMBERS.M_STATE "  &_
	strMemberTablePrefix & "MEMBERS.M_PMRECEIVE " & _

should look like this:

	strMemberTablePrefix & "MEMBERS.M_STATE, "  &_
	strMemberTablePrefix & "MEMBERS.M_PMRECEIVE " & _

Beano_ie
Junior Member

Ireland
328 Posts

Posted - 28 April 2002 : 16:57:39

Thanks Richard

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 28 April 2002 : 17:03:59

you're welcome

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.37 seconds.