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:

&lt;%
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>&lt;-- I want to add this every time create a command</b>
%&gt;

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

Reply to this topic