Re: [sqlite] Capturing output from SQLlite with variables in a BASH script

2007-06-22 Thread spaminos-sqlite
- Original Message From: Martin Jenkins <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Friday, June 22, 2007 2:00:45 PM Subject: Re: [sqlite] Capturing output from SQLlite with variables in a BASH script litenoob wrote: > Hi, I'm wondering how to write a BASH sc

Re: [sqlite] Capturing output from SQLlite with variables in a BASH script

2007-06-22 Thread Martin Jenkins
litenoob wrote: Hi, I'm wondering how to write a BASH script that will capture my SQLite output. I can do it for a single line with something like this: somevar=`sqlite3 dbfilename "SELECT name FROM tablename WHERE name='smith' LIMIT 1;"` However, if I want to do anything with multiple lines,

Re: [sqlite] Capturing output from SQLlite with variables in a BASH script

2007-06-22 Thread Nikola Miljkovic
[In the message "[sqlite] Capturing output from SQLlite with variables in a BASH script" on Jun 22, 13:02, litenoob writes:] > > Hi, I'm wondering how to write a BASH script that will capture my SQLite > output. > > I can do it for a single line with something like this: > > somevar=`sqlite3 db