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
