troubleshooting Question

stored procedure with classic asp

Avatar of michaeldean99
michaeldean99Flag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL ServerProgrammingASP
2 Comments1 Solution422 ViewsLast Modified:
hi
this is an annoying problem!!! Would appreciate some help please.
I am missing something obvious but it is holding me up!

Michael

Classic asp code

invoked by
<%=readSetup("message")%>


Function ReadSetup(SetupKey)
DIM cmdSetupProc
DIM rstSetupProc
DIM ParamSetup

Set cmdSetupProc = Server.CreateObject("ADODB.Command")
cmdSetupProc.ActiveConnection = conn
cmdSetupProc.CommandType = adCmdStoredProc      
cmdSetupProc.CommandText = "GetSetupData"
cmdStoredProc.Parameters.Append .createParameter("@KEY", adVarchar(200), adParamInput,,SetUpKey)
SET rstSetupProc = cmdSetupProc.Execute
ReadSetup=rstSetupProc.Fields("TEXT")
End Function

The stored procedure  is:
USE [xxxxxx]
GO

/****** Object:  StoredProcedure [xxxxx].[GetSetupData]    Script Date: 05/04/2013 16:53:49 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER Procedure [xxxxx].[GetSetupData]
(
      @Key varchar(200)
)
AS
SELECT * FROM [Setup]  WHERE [key] = @Key
ASKER CERTIFIED SOLUTION
Robert Schutt
Software Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros