I have a BS running from MSSQL. (also happens on Derby)
There is a BO with Contact and LastName attributes. As is common in my part of the world we have a lot of surnames with apostrophes in and data loaded from another system has this.
When I try a search with, for example, O'Sullivan, I get errors.
Invalid service parameters for service executeQuery in server message
Is there some way I can get around this in the query definition itself ?
Apostrophe issue with SQL
-
- Posts: 595
- Joined: Sun Apr 24, 2005 2:22 am
- Contact:
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact: