SQL Connection query question
Posted on 2004-11-03
I have a SQL Query that is called from a VBScript, something like the following:
Query = "select UserCount from .....
Set Result = objConn.Execute(Query)
It works just fine. I recently ran into a problem where the query returns no results. If I do this in ISql I get the same response - no records match the query, so the results window is empty.
How would I go about validating the results? If I have something like:
wscript.echo Result("UserCount") after a query that returns no results I get an error.