Carl Lindgren wrote:
Could someone please give me a clue on why I'm getting this message "SQL
error: unrecognized token: ""select" "
from the command line using Bash for Dos and a sh script?
Thanks for any help,
Carl
-- Carl Lindgren C. R. Lindgren Consulting / Business on the Desktop
Using Bash for Dos and MS-KSH
-------------------------------------------------------------------------------------------------------------------------------------
>>>Script<<< #!/foobar/bash desired_data=Test DB_Path="/foobar/foo_DB"
DB_Statement="\"select Data_Value from Table_Name where Data_Key =
'$desired_data' ; \"" Sql_return=$(sqlite3.exe "$DB_Path"
$DB_Statement) echo $Sql_return >>>End Script<<< >>>OUTPUT<<< sqlite3
/foobar/foo_DB "select Data_Value from Table_Name where Data_Key =
'Test' ; " SQL error: unrecognized token: ""select" >>> END OUTPUT<<<
-- Carl Lindgren C. R. Lindgren Consulting / Business on the Desktop
_______________________________________________ sqlite-users mailing
list sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I figured it out...
DB_Path=c:/foobar/foo_DB
DB_Statement="select Data_Value from Table_Name where Data_Key =
'$desired_data' ; "
Sql_return=$(sqlite3.exe $DB_Path "$DB_Statement")
echo $Sql_return
I had the quotes wrong.
--
Carl Lindgren
C. R. Lindgren Consulting / Business on the Desktop
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
