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: Database: MS Access
 Bad word filter error		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

tmcveagh
Starting Member

3 Posts
Posted - 02 July 2001 :  11:12:58  Show Profile
Hi

When I try to update the bad word filter with more than one word, I get the following message

"Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in string in query expression ''bad|word''.

/forums/snitz/admin_config_badwords.asp, line 71"

Anyone any ideas?

RDoGG™
Junior Member

USA
329 Posts
Posted - 03 July 2001 :  19:08:01  Show Profile  Visit RDoGG™'s Homepage  Send RDoGG™ an AOL message  Send RDoGG™ a Yahoo! Message
quote:

Hi

When I try to update the bad word filter with more than one word, I get the following message

"Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in string in query expression ''bad|word''.

/forums/snitz/admin_config_badwords.asp, line 71"

Anyone any ideas?




remove the pipe

someone reported that they had an error with pipes.
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 03 July 2001 :  19:10:15  Show Profile
No, the pipe is the required seperator for the words. Are you entering it like this:

bad|word

or like this:

bad|word|
Go to Top of Page

tmcveagh
Starting Member

3 Posts
Posted - 04 July 2001 :  04:39:25  Show Profile
quote:

No, the pipe is the required seperator for the words. Are you entering it like this:

bad|word

or like this:

bad|word|




I've been entering it "bad|word" ...
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 05 July 2001 :  01:21:04  Show Profile
are you putting the quotes? If so, that's the problem.
Go to Top of Page

tmcveagh
Starting Member

3 Posts
Posted - 05 July 2001 :  04:34:10  Show Profile
quote:

are you putting the quotes? If so, that's the problem.

I'm not putting the quotes.
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 0.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07