Hello
I have a problem scripting with sqlite3
I can use, on the same bash the line
sqlite3
/Users/alberto/Documents/Casa/Domótica/Programas/cronizados/WeatherTracker/casa\
Database.sdb "select OutsideTemp from WXData where
RecDateTime>='2011-12-07 21:22' and RecDateTime<='2011-12-07 21:27' and
RecordType='R';"
This gives me the result (being a number)
If I use the same line inside a bash script like:
TomaCampo=sqlite3
/Users/alberto/Documents/Casa/Domótica/Programas/cronizados/WeatherTracker/casa\
Database.sdb "select OutsideTemp from WXData where
RecDateTime>='2011-12-07 21:22' and RecDateTime<='2011-12-07 21:27' and
RecordType='R';"
It raises me up an error:
/Users/alberto/Documents/Casa/Domótica/Programas/cronizados/WeatherTracker/pruebaSqLite:
line 27:
/Users/alberto/Documents/Casa/Domótica/Programas/cronizados/WeatherTracker/casa
Database.sdb: Permission denied
The file "casa Database.sdb" has read rights for owner, group and others
Any ideas how to deal with this matter?
Thank you,
Zenaida
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users