On Wed, Mar 28, 2001 at 12:04:25PM -0600, Chad C. Walstrom wrote:
It looks like I'll have to go with raw data output, probably pipe-delimited with the $MSG text as the last field. I could see the next iteration of the template() option to be an escaped version, where you can specify what your escape character should be and which characters it should apply to. Something like:
destination{ file("/tmp/blah" template( "$MSG" escape("\") to-escape("'\"\\") ) ); };
That seems like overkill. You need an external program to catch the data/SQL statements anyway and insert the data/run the SQL statements. Why not output the data as data, and have the external program deal with generating your SQL statements while escaping any characters you need escaped? - Morty