PaulCAust — Sun, 18 Nov 2001 22:39:43 +0000

Right OK. I will have to play around with this a bit. The RecordsAffected property retured by the Execute method seems to be giving me what I need within Access.

Thanks Guys.

Peter J. Boettcher — Fri, 16 Nov 2001 13:23:37 +0000

Yeah, those are just the variable names to pass the values between the ASP page and the stored procedure. So "ioAction" is the same as "SPResult" from my example.

Mark Hensler — Fri, 16 Nov 2001 07:18:31 +0000

This is what I found from the link above...

Set pAction = oCmd.CreateParameter("ioAction",131,3,50,0)
oCmd.Parameters.Append pAction

Set pMessage =
oCmd.CreateParameter("ioMessage",200,3,50,"")
oCmd.Parameters.Append pMessage

oCmd.Execute
  if ( oCmd("ioAction") <> 0 ) then
Response.Write( oCmd("ioMessage") )
end if

'I looked up CreateParameter() in an ASP book I have, and it was the next page after my bookmark. From what I can tell, there is nothing special about ioAction and ioMessage. They are simply the names assigned to those parameters.

That's all I can say. I haven't used ASP in about a year, so I haven't had any motivation to finish that book.

Stored Procedures

PaulCAust — Thu, 15 Nov 2001 22:58:17 +0000

The 15Seconds Article
The article is titled Calling Stored Procedures From Active Server Pages (a very creative title I thought) by Al Hetzel.

URL: http://www.15seconds.com/Issue/000810.htm

Paul

Peter J. Boettcher — Thu, 15 Nov 2001 14:28:33 +0000

Paul,

Whenever I want to check the result of a stored procedure I usually use a "return" value or an "output" value. This return value could be the number of returned records, an error number, whatever you want. Here's a quick sample stored proc:

CREATE PROCEDURE ClienteleAdmin.Client_Site_Search_Inventory
(
@SPResult varchar(50) = NULL OUTPUT
)

DECLARE @Records integer

SELECT @Records = ID FROM Sometable

IF @@ROWCOUNT > 0 @SPResult = "Found Records" ELSE @SPResult = "Found None"

RETURN

I just did a select because I didn't feel like typing to much, but the same methodology can be used for inserts/updates/deletes.

I have never used (or heard of) ioAction & ioMessage, I'll have to check out that article.