Hi
In my application, I call Visual Basic COM Component from ASP file.
The component returns a recordset as a variant.
Some part of the code for component is like
Public Function Return_Record() As Variant
Dim Sql As New ADODB.Command
Dim myconnection As New ADODB.Connection
Dim RS as new Recordset
Dim varconnection
Dim delete_status As String
On Error GoTo Error_Message 'Error_Message
myconnection.Open (mvarConnection_String)
MsgBox " before insert "
number = mvarNumber
With Sql
.ActiveConnection = mvarConnection_String
.CommandType = adCmdStoredProc
.CommandText = "SP_Get_News"
.Parameters.Append .CreateParameter("@number", adInteger, adParamInput, 4, mvarNumber)
End With
RS=Sql.execute
Return_Record = RS
MsgBox " after insert, before delete"
-------
--------
--------
---------
end function
In ASP, I will create an instance of the object and call the above function and assign the returned data to a variable of the type record set.
I want to access it as a record set. If the function in Visual Basic component returns a record set as a variant, can I access it as a record set in a ASP?
How do you do it?
Waiting for suggestions
Thanks
Smita
In my application, I call Visual Basic COM Component from ASP file.
The component returns a recordset as a variant.
Some part of the code for component is like
Public Function Return_Record() As Variant
Dim Sql As New ADODB.Command
Dim myconnection As New ADODB.Connection
Dim RS as new Recordset
Dim varconnection
Dim delete_status As String
On Error GoTo Error_Message 'Error_Message
myconnection.Open (mvarConnection_String)
MsgBox " before insert "
number = mvarNumber
With Sql
.ActiveConnection = mvarConnection_String
.CommandType = adCmdStoredProc
.CommandText = "SP_Get_News"
.Parameters.Append .CreateParameter("@number", adInteger, adParamInput, 4, mvarNumber)
End With
RS=Sql.execute
Return_Record = RS
MsgBox " after insert, before delete"
-------
--------
--------
---------
end function
In ASP, I will create an instance of the object and call the above function and assign the returned data to a variable of the type record set.
I want to access it as a record set. If the function in Visual Basic component returns a record set as a variant, can I access it as a record set in a ASP?
How do you do it?
Waiting for suggestions
Thanks
Smita