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
 Searching members error		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Beano_ie
Junior Member

Ireland
328 Posts
Posted - 28 April 2002 :  16:40:14  Show Profile  Visit Beano_ie's Homepage
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  Show Profile
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 " & _
Go to Top of Page

Beano_ie
Junior Member

Ireland
328 Posts
Posted - 28 April 2002 :  16:57:39  Show Profile  Visit Beano_ie's Homepage
Thanks Richard
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 28 April 2002 :  17:03:59  Show Profile
you're welcome
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.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07