I am trying to set up sending a stored procedure as a sub so I can reuse it just by passing in the proc name.
when I run the code straight it works. when I turn it into a sub with the variable as the procedure name and try to run it, it doesn't work.
Did I code something wrong?
set viewDates = Server.CreateObject("ADODB.Command")
viewDates.ActiveConnection = MM_TowerConn2_STRING
viewDates.CommandText = procedure
viewDates.Parameters.Append viewDates.CreateParameter("@ShadchinId", 200, 1,50,Session("MM_Username"))
set viewDatesList = viewDates.Execute