Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  working with stored procedures

Author  Topic  zara Starting Member 3 Posts Posted - 2000-12-01 : 08:55:19 I have been trying to create a log view through stored procedures. I am having trouble calling the procedure and getting results back. All I want it to do is return records from five different columns. All help is greatly appreciated, thank you for your advice and time. Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open application ("pmisconn") Set logcommand = Server.CreateObject("ADODB.Command") logcommand.ActiveConnection = Conn logcommand.Type = adCmdStoredProc logcommand.CommandText = "LogView_SP" logcommand.Parameters.Append logcommand.CreateParameter("ReturnCode", adInteger, adParamReturnValue) Set Rs = logcommand.Execute While Not Rs.EOF %> <% Rs.MoveNext Wend RS.Close