Microsoft JET Database Engine error '80040e14'I'm trying to submit my description. But i get this.
Syntax error (missing operator) in query expression
/pettingzoo/submitdesc.asp, line 34
I'm trying to add Description:
To Jomty is to enter a (chat)room and say hi to one person in particular and then say hi to everyone else in one go.
And example of usage:
Dave has entered the chat.
Dave: Hi Fnord, hi everyone.
J8: Did you see that? He jomtied Fnord when he came in, where's MY hello?
Fnord: Hi Dave, nice jomty there.
(Syntax error (missing operator) in query expression
/pettingzoo/submitdesc.asp, line 34
I'm trying to add Description:
To Jomty is to enter a (chat)room and say hi to one person in particular and then say hi to everyone else in one go.
And example of usage:
Dave has entered the chat.
Dave: Hi Fnord, hi everyone.
J8: Did you see that? He jomtied Fnord when he came in, where's MY hello?
Fnord: Hi Dave, nice jomty there.
Professor Fnord Regius Professor of B3ta Chronology,
Thu 14 Feb 2002, 14:54,
archived)
its because....you had a ' in the example. For some reason it hates having ' characters in a database
anyone know a workaround? i'm using asp
(,
Thu 14 Feb 2002, 16:36,
archived)
anyone know a workaround? i'm using asp
WorkaroundAdd some script that doubles up the quotes, e.g.
Set regEx = New RegExp
regEx.Pattern = '''
NewStatement = regEx.Replace(OldStatement, '''')
Or something like that.
Hope that helps!
(,
Thu 14 Feb 2002, 16:45,
archived)
Set regEx = New RegExp
regEx.Pattern = '''
NewStatement = regEx.Replace(OldStatement, '''')
Or something like that.
Hope that helps!
Ahh CheersI had missed that because i wasn't using it as a speech mark.
Thanks.
(Thanks.
Professor Fnord Regius Professor of B3ta Chronology,
Thu 14 Feb 2002, 18:37,
archived)