While the example of how to insert data into sqlite, here:
http://www.sqlite.org/cvstrac/wiki?p=ShellScript
works well, I have been less than successful in retrieving data from sqlite, eg bashvar=<sqlite command>; echo "result of query = $bashvar".
It would be a pity if such an otherwise wonderful product should fail at the second hurdle. Or perhaps its just my bash non-skills...
Any ideas?