apostrophy error

[Trillithium]

Hi,

When I enter a word with an apostrophy ( like 's or s') into a textbox/field and submit it to a database (access) I get an "operator missing syntaxis error" in my query expression. Can somebody tell me what to do.

Thanx

 

[link9]

You need to add the escape character, which, strangely enough, is the apostrophe --

Just run this on all strings you are going to run to the db --

replace(string, "'", "''&quot

So that every time it finds an apostrophe, it replaces it with two apostrophes.

Although, if you want to really save yourself some headaches and you have creative control over the data, just make apostrophes illegal, and run this on the strings:

replace(string, "'", "&quot

To just take them out --

Of the two, I highly recommend the second option, but not everyone is lucky enough to be able to make that rule.

good luck!
Paul Prewett

 

[Trillithium]

Thanx it worked