recordset not returning value from SQL server

[sean]

HI There,

I am having a little trouble displaying a recordset from SQL Server and I
was wondering if someone could have a look at my code to see what I have
missing?
I can execute the stored procedure successfully in the query analizer, I
just can't get the records to show on the page.

Sean - thanks in advance


!-- stored procedure

CREATE PROCEDURE GetLargeImages

@productID int
AS

SELECT image1Large, image2Large FROM
tblProducts WHERE productID=@productID
GO


!-- code


Set adoRec = Server.CreateObject("ADODB.Recordset")
Set adoCmd = Server.CreateObject("ADODB.Command")
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open dbConnectionStr

adoCmd.ActiveConnection = objConn
adoCmd.CommandType = adCmdStoredProc
adoCmd.CommandText = "GetLargeImages"

Set PID = adoCmd.CreateParameter("productID", adInteger, adParamInput,4)
adoCmd.Parameters.Append PID

Set adoRec = adoCmd.Execute

response.write adoRec("image1Large")

response.End

[Aaron [SQL Server MVP]]

What is the data type of image1Large? What string is in dbConnectionStr?

How about:

Set conn = CreateObject("ADODB.Connection")
conn.Open dbConnectionStr
set rs = conn.execute("EXEC GetLargeImages")
response.write rs(0)
rs.close: set rs = nothing
conn.close: set conn = nothing