I have a script which will format some text and create a simple mysql
query. The next thing I'd like the script to do is run a batch file to
open a mysql session from my client pc, execute the query from the temp
variable and save the results to a file.
Const ForReading = 1
Const ForWriting = 2
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile("c:\scripts\Test.txt", ForReading)
strSearchString = objFile.ReadAll
temp = Replace(strSearchString, VbCrLf & VbCrLf, "','")
temp = "select * from company where name in ('" & temp & "');"
Set objFile = objFSO.OpenTextFile("c:\scripts\Test.txt", ForWriting)
The commands I want the script to do would be something like:
c:\mysql\bin\mysql -uxxx -p123 -h192.168.0.1 dbname
<execute query from temp variable>
How or can I incorporate this into the above vbscript?