Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
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.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - execute mysql query using vbscript

Reply
 
Old 06-09-2009   #1 (permalink)
James


 
 

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 SpecsSystem Spec
Reply

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


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46