RE: Escaping strings in SQL scripts

2006-04-27 Thread Anderson, Rob (Global Trade)
> From: Ray Madigan [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 27, 2006 8:59 AM > To: Ant Users List > Subject: Escaping strings in SQL scripts > > I have a bunch of functions that I need to write to my SQL > database. The functions contain quoted strings that sp

Escaping strings in SQL scripts

2006-04-27 Thread Ray Madigan
I have a bunch of functions that I need to write to my SQL database. The functions contain quoted strings that span many lines like 'DECLARE seq RECORD; BEGIN SELECT * INTO seq FROM ...; IF FOUND THEN UPDATE ...; END IF; IF NOT FOUND THEN RETURN ...; END IF; RETURN NULL; END;' Is