Jump to content

Single quotes in the values of an update statement


Kai Benndorf
 Share

This topic is 6509 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi all,

i'm using the JDBC driver from FileMaker together with Apache's Cocoon to build a web application. On updating my data i create a SQL statement containing a single quote in the new value, like the following:

update "Produkt.fp5" set name='Thank's'

It don't work, i receive a error message from FilemMaker. I tried to escape the single quote with '', ', %27, and some other, but i don't get it to work.

I've found a similar thread in this forum, but without solution. Is there really no solution to this problem ?

Many thanks in advance

Kai

Link to comment
Share on other sites

  • Newbies

I don't have currently the exact error text at hand, but the error message was something about an incorrect SQL statement.

The statement:

update "Produkt.fp5" set name='Thank's'

is only an simplified example, the real statements updates several additional fields.

Link to comment
Share on other sites

  • Newbies

The values to be set in the database originated from a wen form and thus i can't prevent the user to type in an apostrophe. I've already implemented the exchange of the apostrophe with an backquote, but this is still incorrect. It#s not the data the user wants to write in the database

Link to comment
Share on other sites

  • 4 weeks later...

This topic is 6509 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.