Passing mysql data via cmd line to an .exe?
am 05.03.2006 06:55:38 von SerpicoI have an Windows .exe that I need to pass flags to that would be data
pulled from a mysql DB. This exe file with args will be automatically
run via the task scheduler. That part I can do. :)
Example: someapp.exe -pid -cid -sid
pid, cid, and sid are arguments that are currently stored in a mysql
DB. I expect a shell script would be the way to go, but I haven't
written one in years.
I suspect the shell script would query the DB, then pass the args to
someapp.exe
1: How would I query the DB via a shell script?
2: How would I pass the resultant data retreived to someapp.exe?
I haven't a clue how to do this ... any advice/example would be greatly
appreciated.
Thanks!