Return Value Into ActiveX Task Local Variable

[EdwinGene]

I have set up an ADO connection to a SQLServer DB in VBScript in an ActiveX Task. What I want to do is return a uniqueidentifier value from this connection directly to a local variable in the script.

The essential parts of my code are as follows:

Dim strSQL, strResult
strSQL = "Select NewId()"
strResult = ADOConnection.Execute strSQL


I get an "expected end of statement" error on the SQL Execute statement.

Is there a way to return a value from the select statement directly to a local variable in the ActiveX script?

 

[yksvaan]

I think you are asking a way round the following, but manual puts it out something like this. I think Execute method always returns a resultset.

Dim rs As ADODB.Recordset
Dim fld As ADODB.Field
...
rs = ADOConnection.Execute(strSQL)
Set Flds = rs.Fields
For Each fld In Flds
strResult=fld.Value
Next
rs.Close

Cheers


[blue]Backup system is as good as the latest recovery[/blue]