Forums
This topic is locked
Modifying the Command (Stored Procedure) Behaviour
Posted 10 Apr 2002 15:52:41
1
has voted
10 Apr 2002 15:52:41 Owen Eastwick posted:
I have altered my recordset behaviour to include <b>Set rsName = Nothing</b>after the <b>rsName.Close()</b>.
I would like to do something similar for the Command (Stored Procedure) code so I get something like:
<%
set comName = Server.CreateObject("ADODB.Command"
comName.ActiveConnection = MM_RHconnect_STRING
comName.CommandText = "spAdminPageInsert"
comName.Parameters.Append comSpAdminPageInsert.CreateParameter("@RETURN_VALUE", 3, 4)
comName.Parameters.Append comSpAdminPageInsert.CreateParameter("@SomeVariable", 200, 1,50,comName__Whatever)
comName.CommandType = 4
comName.CommandTimeout = 0
comName.Prepared = true
comName.Execute()
Set comName = Nothing <b><-- I want to add this every time create a command</b>
%>
Trouble is I can't find the original to modify, anyone know where I should look/what it's called?
Regards,
Owen.
Replies
Replied 11 Apr 2002 04:12:58
11 Apr 2002 04:12:58 Owen Eastwick replied:
It's OK, I've learned my lesson, unless you are particularly fond of red exclamation marks - leave it alone.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo