Re: [sqlite] Re: apostrophe troubles

2006-04-13 Thread Brian Johnson
Thanks .. it's amazing how hard it is to google for this info Igor Tandetnik ([EMAIL PROTECTED]) wrote: > > Brian Johnson > <[EMAIL PROTECTED]> wrote: > > Here is example of what I'm trying to do in the bash script: > > > > sqlite3 db.dat "BEGIN; > > UPDATE table1 SET name='O'Neil' WHERE person_

[sqlite] Re: apostrophe troubles

2006-04-12 Thread Igor Tandetnik
Brian Johnson <[EMAIL PROTECTED]> wrote: Here is example of what I'm trying to do in the bash script: sqlite3 db.dat "BEGIN; \ UPDATE table1 SET name='O'Neil' WHERE person_id=2 \ COMMIT;" there are more UPDATE lines or I wouldn't bother with the BEGIN; and COMMIT; .. but the real problem is tha