Re: [Pharo-users] [Garage] How to espace sql special chars in a query?

On 12 Aug 2016, at 10:34, Blondeau Vincent <vincent.blondeau@worldline.com> wrote:

Hello,

Hi

I am looking for a method that escape special characters for SQL queries. E.g.: I want to escape : ‘ in a where expression: ‘….Where field1 = ‘’‘, myvariable , ‘‘’ …..’ with myvariable := ‘don’’t do’. I am using garage and haven't found it in the package. Does someone know where I can found it?

I have used prepared statements for that. They allow me to bind the variable to the statement and I don't have to worry about escaping (at least that is the theory). holger