troubleshooting Question

what are the values for second parameter value for CreateParameter in ASP

Avatar of ram27
ram27 asked on
ASP
4 Comments1 Solution339 ViewsLast Modified:
Hi
i want to call sql server storedproc (myproc) from asp code (classic ASP)
create  PROCEDURE [dbo].[myproc]
(
    @mailid            uniqueidentifier OUTPUT,
    @user_guid         uniqueidentifier,
    @mailtype          integer,
    @toaddress         varchar(128) = NULL,
    @subject           varchar(256) = NULL,
    @Textbody              varchar(MAX) = NULL,
             @std_msgid         int = NULL,
    @att1              varchar(128) = NULL,
    @att2              varchar(128) = NULL,
    @att3              varchar(128) = NULL,
             @HTMLBody           varchar(MAX) = null

)
...
how to pass parameters for thsi
cn.Open "data source name", "userid", "password"
   Set cmd = Server.CreateObject("ADODB.Command")
   Set cmd.ActiveConnection = cn
   cmd.CommandText = "[dbo].[myproc]"
   cmd.CommandType = adCmdStoredProc
what will be value for second parameter for
   cmd.Parameters.Append cmd.CreateParameter("@mailid ",??what is the value ???, _
      adParamReturnValue)
   cmd.Parameters.Append cmd.CreateParameter("@user_guid",???adVarChar??, _
      adParamInput)
      cmd.Parameters.Append cmd.CreateParameter("@user_guid",,adVarChar, _
      adParamInput)
Please let me know

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
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 4 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