asp_databases thread: - Microsoft VBScript runtime error `800a01f9` Invalid or unqualified reference
Following is my code in ASP
<%
Dim cmdUpdate
Dim lngRecs
Dim sec
Dim count
sec = 1
set con = Server.createObject("ADODB.Connection")
con.open session("conn")
set cmdUpdate=Server.CreateObject("ADODB.Command")
cmdUpdate.ActiveConnection = con
cmdUpdate.CommandText = "usp_latestnews1"
Call.cmdUpdate.Parameters.Append.CreateParameter
("@sectionid",adSmallInt,adParamInput,10,1)
Call.cmdUpdate.Parameters.Append.CreateParameter
("@count",adSmallInt,adParamOutput)
cmdUpdate.Execute lngRecs,,adExecuteNoRecords
Gives an error saying..
Microsoft VBScript runtime error `800a01f9`
Invalid or unqualified reference
In the line, Call.cmdUpdate.Parameters.Append.CreateParameter
("@sectionid",adSmallInt,adParamInput,10,1)
what can the problem be?Can anyone help?