Correction:
FOR /F "tokens=1" %%A IN (machinelist.txt) DO (
sqlite3.exe dropped.db "INSERT INTO DropDB_log(date, ip_address,
status) VALUES (%DATE%, %%A, '%STATUS%');"
)
The file SET must be in parentheses.
On 2016/09/26 10:09 PM, R Smith wrote:
I can't test this since I don't have your file or DB, but it should
put you on the right track. This example assumes only 1 IP address on
each line and will ignore any other tokens.
FOR /F "tokens=1" %%A IN "machinelist.txt" DO (
sqlite3.exe dropped.db "INSERT INTO DropDB_log(date, ip_address,
status) VALUES (%DATE%, %%A, '%STATUS%');"
)
(Notice all the unnecessary DB quotes and backticks removed - those
are only needed when the string doesn't make sense in machine terms,
and these all are o.k.)
HTH,
Ryan
On 2016/09/26 9:34 PM, jungle Boogie wrote:
Hi All,
I'm attempting to make a windows batch file that reads a text file and
inserts a new record for each entry:
sqlite3.exe dropped.db "INSERT INTO
`DropDB_log`(`date`,`ip_address`,`status`) VALUES
(%DATE%,readfile('machinelist.txt'),'%STATUS%');"
Right now, it does this:
date,ip_address,status20160926,128.10.10.1
128.10.10.3
128.10.10.4
128.10.10.5,up
I'd like this:
20160926,128.10.10.1,up
20160926,128.10.10.3,up
20160926,128.10.10.4,down
20160926,128.10.10.5,up
Will the readfile + the separator command allow this kind of hackery
in windows batch files?
Thanks!
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users