Re: [sqlite] Two commands at once

2008-02-16 Thread Fred J. Stephens
Derrell Lipman wrote: > On Feb 16, 2008 12:01 PM, Fred J. Stephens <[EMAIL PROTECTED]> wrote: >> How can I issue 2 commands to SQLite at the same time in a shell script? >> I want to temporarily change the separator for the returned data, >> something like: >> sqlite3 database.db ".separator " ", S

Re: [sqlite] Two commands at once

2008-02-16 Thread Derrell Lipman
On Feb 16, 2008 12:01 PM, Fred J. Stephens <[EMAIL PROTECTED]> wrote: > How can I issue 2 commands to SQLite at the same time in a shell script? > I want to temporarily change the separator for the returned data, > something like: > sqlite3 database.db ".separator " ", SELECT first,last FROM addres

[sqlite] Two commands at once

2008-02-16 Thread Fred J. Stephens
How can I issue 2 commands to SQLite at the same time in a shell script? I want to temporarily change the separator for the returned data, something like: sqlite3 database.db ".separator " ", SELECT first,last FROM address;" But I can't get it to work. Thanks.