Escape single quote in string

[DDE]

Hi,

wich way can I escape a string sent to an OleDbComman containing single
quote?

Thanks

Dominique

[William Ryan]

Use an OledbParameter instead and let it take care of it for you.
"DDE" <dd*@iaireinfo.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi,

wich way can I escape a string sent to an OleDbComman containing single
quote?

Thanks

Dominique

[Ignacio Machin]

Hi,

I think that it depends of the DB engine you are talking to. I would search
on the product documentation first and/or not found I would try escape it
with the same ' , with a " or enclosing the string in [ ]

Hope this help,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"DDE" <dd*@iaireinfo.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi,

wich way can I escape a string sent to an OleDbComman containing single
quote?

Thanks

Dominique

[DDE]

Hi,

I am not using Parameters in this case, I am just lookin for a method to do
the thing.

Dominique

"William Ryan" <do********@comcast.nospam.net> wrote in message
news:eq**************@tk2msftngp13.phx.gbl...

Use an OledbParameter instead and let it take care of it for you.
"DDE" <dd*@iaireinfo.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi,

wich way can I escape a string sent to an OleDbComman containing single
quote?

Thanks

Dominique

[DDE]

I am not using a constant string but a structure element.

Dominique
"Ignacio Machin" <ignacio.machin AT dot.state.fl.us> wrote in message
news:#4**************@TK2MSFTNGP09.phx.gbl...

Hi,

I think that it depends of the DB engine you are talking to. I would search on the product documentation first and/or not found I would try escape it
with the same ' , with a " or enclosing the string in [ ]

Hope this help,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"DDE" <dd*@iaireinfo.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi,

wich way can I escape a string sent to an OleDbComman containing single
quote?

Thanks

Dominique

[William Ryan]

Typically, if you Do a string.replace and replace the single quote with
double quotes, it will work for most RDBMS systems. This will do it even if
there's no quote present, the replace will just be ignored. I highly
recommend against this type of methodology, but if you are sure this is what
you want to do...

Dim s As String = "O'Brien"

MessageBox.Show(s.Replace("'", "''"))

"DDE" <dd*@iaireinfo.com> wrote in message
news:O3**************@TK2MSFTNGP11.phx.gbl...

Hi,

I am not using Parameters in this case, I am just lookin for a method to do the thing.

Dominique

"William Ryan" <do********@comcast.nospam.net> wrote in message
news:eq**************@tk2msftngp13.phx.gbl...

Use an OledbParameter instead and let it take care of it for you.
"DDE" <dd*@iaireinfo.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi,

wich way can I escape a string sent to an OleDbComman containing single quote?

Thanks

Dominique

[Ignacio Machin]

Hi,

At the end you will have to assign the query to OleDbCommand.CommandText ,
this is a string property, this is where you can do the substitution I'm
talking about

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"DDE" <dd*@iaireinfo.com> wrote in message
news:Or*************@TK2MSFTNGP11.phx.gbl...

I am not using a constant string but a structure element.

Dominique
"Ignacio Machin" <ignacio.machin AT dot.state.fl.us> wrote in message
news:#4**************@TK2MSFTNGP09.phx.gbl...

Hi,

I think that it depends of the DB engine you are talking to. I would

search

on the product documentation first and/or not found I would try escape it with the same ' , with a " or enclosing the string in [ ]

Hope this help,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"DDE" <dd*@iaireinfo.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi,

wich way can I escape a string sent to an OleDbComman containing single quote?

Thanks

Dominique