I have read http://www.sqlite.org/sqlite.html
I want to get something like this working:
[C:\test.js]
WS=new ActiveXObject('WScript.Shell')
WS.Run('C:\\sqlite.exe "C:\\test.db" .read "C:\\query.txt" .output
"C:\\OUT.txt" ')
[C:\query.txt] contains...
select * from sqlite_master;
What's up?
I have searched for links to sample command usage
and sample databases. please help.
[C:\whatever.js] If I try this, I lose the context of the previous settings...
WS=new ActiveXObject('WScript.Shell')
WS.Run('C:/sqlite.exe "C:/test.db"')
WS.Run('.read "C:\\query.txt"')
WS.Run('.output "C:\\OUT.txt"')
I would love it if all settings could be read from a single command file...
(settings=command line options, path to database file, SQL )
[C:\test.js]
WS=new ActiveXObject('WScript.Shell')
WS.Run('C:\\sqlite.exe -input "C:\\commands.txt" -output "C:\\result.txt" ')
joshdon
brisbane australia
---------------------------------
Do you Yahoo!?
Meet the all-new My Yahoo! – Try it today!
