![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| | execute mysql query using vbscript 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 |
My System Specs![]() |
![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| how to execute query which is use to truen result like pivot table | .NET General | |||
| MySQL query | VB Script | |||
| Execute VBScript from a floating popup menu | VB Script | |||
| Can't execute T-SQL query | PowerShell | |||
| i cannot connect to my odcb driver, mysql .. need query string | PowerShell | |||