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_id=2 > > COMMIT;" > > > > there are more UPDATE lines or I wouldn't bother with the BEGIN; and > > COMMIT; .. but the real problem is that apostrophe. I've tried every > > type of excape that I can think of > > name='O''Neil' > > And you are missing a semicolon at the end of UPDATE statement, before > the COMMIT. > > Igor Tandetnik > >