Apostrophe issue with SQL

denisv · Post by **denisv** » Wed Jan 24, 2007 12:02 pm

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 ?

aware_support2 · Post by **aware_support2** » Thu Jan 25, 2007 9:34 am

Seems like a bug. We will be fixing it shortly.

aware_support · Post by **aware_support** » Wed Jan 31, 2007 11:27 am

This has been fixed starting from build 943