Re: [sqlite] Changing row separator to null when accessing sqlite frombash script

On 07/19/11 01:41 PM, Igor Tandetnik wrote: > Richard Taubo wrote: >> I have a bash script like this: >> >> #!/bin/bash >> OIFS=$IFS >> IFS=$'\n'; >> sql_command=`sqlite3 -noheader /My/Path/To/DB/ex1 "select one from tbl1 >> WHERE one LIKE '%this%';"` >> for i in $sql_command >> do >> echo

Re: [sqlite] Changing row separator to null when accessing sqlite frombash script

Richard Taubo wrote: > I have a bash script like this: > > #!/bin/bash > OIFS=$IFS > IFS=$'\n'; > sql_command=`sqlite3 -noheader /My/Path/To/DB/ex1 "select one from tbl1 WHERE > one LIKE '%this%';"` > for i in $sql_command > do >echo "$i" > done > IFS=$OIFS; > > > Since the column "one" co