Re: thinking through parsing multi-line database commands with cr in the data

2013-05-26 Thread Peter Haworth
I'd be inclined to have a handler to execute/buffer the SQL statements based on what type of db is in use. For example you could have a handler dbCommand which took SQL statements as a parameter. If the DB is SQLite, the handler would execute the statement immediately. If some other version of S

Re: thinking through parsing multi-line database commands with cr in the data

2013-05-26 Thread Dave Probert
Hi, I found that the simplest route for me when working with multi-line field data was to pre-parse the data on storage and post parse it on extraction, by changing the 'cr''s to either another seldom used character or html (eg. ''). So the database code before the INSERT/UPDATE would replace and