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.

dim temp,objFSO,objFile
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)
objFile.Write temp
objFile.Close



The commands I want the script to do would be something like:

echo off
c:\mysql\bin\mysql -uxxx -p123 -h192.168.0.1 dbname

cmd

tee result.txt

<execute query from temp variable>

end

How or can I incorporate this into the above vbscript?

Thanks,

James