Solved Please help me in the given VB script

June 25, 2013 at 06:51:39
Specs: Windows Server 2003

Please help me in the given VB script.

Here Im executing the SQL query.
If the record count of the Query is 1 i need to send Successfull notifcation through mail, if record count is not 1 i need to send the failure notification

My code :

ConnectString = "Driver={SQL Server};Server=FATESTRPT\FATEST;Database=sy_utility"
Const SummaryQuery = "select * from Table111 where ProcessID = 53 "

Set fso = CreateObject("Scripting.FileSystemObject")
Set com = CreateObject("ADODB.Command")
com.ActiveConnection = ConnectString
com.CommandText = SummaryQuery
Set rs = com.Execute
' Here I need help"
'If RS record Count is 1 Send Mail Successfull
'Else falure Mail

See More: Please help me in the given VB script

Report •

June 25, 2013 at 12:30:34
✔ Best Answer
You can probably get what you need from this recent thread:

and here's a how-to vbs front-end to the same code (handles the parameters):

Report •
Related Solutions

Ask Question