How to handle last_name = 'O'connor' error

[adonet]

In SQL statement, if write "where last_name = 'O'connor'"
will cause an error. How to handle it?

 

[influent1]

Depends. Do you want to handle it in the VB code or the SQL code? If VB, then:

Replace(<name as string>, "'", "''")

 

[influent1]

In case that's hard to read, you're replacing the single quote with two single quotes.

 

[chrissie1]

or use parameters as suggested before.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[chiph]

I strongly suggest using ADO parameters. Do a Google search for "SQL Injection".

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first