Inserting statement with single quote

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kamuixkotori - 23 Oct 2006 07:27 GMT

Hello,

Does anyone know how to insert/update data that contains single quote (')
into a field? Data such as: John's house is in Dalas.

I know one can insert double quote by using single quotes as field
delimiters. But since I have to use single quotes as field delimiters, data
cannot contain single quote. Is there a way to change the field delimiter?

I try escaping the single quote by adding a "\" before the single quote like
the example below, but it still won't work? why? I using Microsoft Access.

'John\'s house is in Dalas'

Reply to this Message

Damian S - 23 Oct 2006 07:53 GMT

Hi kamuixkotori,

You need to replace single quotes in your SQL String with two single quotes...

eg: strSQL = replace(strSQL, "'", "''")

that's double quote, single quote, double quote
then double quote, two single quotes, double quote

Hope this helps.

Damian.

> Hello,
>
[quoted text clipped - 9 lines]
>
> 'John\'s house is in Dalas'

Reply to this Message

kamuixkotori - 23 Oct 2006 08:46 GMT

In the SQL view of Microsoft Access it can work.. but in java runtime it give
'java.sql.SQLException: General error' error message.. how come?

> Hi kamuixkotori,
>
[quoted text clipped - 22 lines]
> >
> > 'John\'s house is in Dalas'

Reply to this Message

kamuixkotori - 23 Oct 2006 09:47 GMT

Hmm.. btw.. it can work already.. thanks a lot!

> In the SQL view of Microsoft Access it can work.. but in java runtime it give
> 'java.sql.SQLException: General error' error message.. how come?
[quoted text clipped - 25 lines]
> > >
> > > 'John\'s house is in Dalas'

Reply to this Message