Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: - Microsoft VBScript runtime error `800a01f9` Invalid or unqualified reference


Message #1 by david@i... on Tue, 19 Mar 2002 09:16:02
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?

Message #2 by zines <zines@z...> on Tue, 19 Mar 2002 17:24:21 +0800
SXMgdGhlcmUgYSBjbWRUeXBzIHRoZXJlPw0K



  Return to Index