How to pass parameter to store procedure from asp

• Ish Fad

  Old Hand

  Points: 353

  More actions

  July 29, 2010 at 3:28 am

  #224759

  Hi

  I wounder some could help me. I am bit new to store procedure and asp.

  I have store procedure like below;

  ALTER PROCEDURE [dbo].[getStaff]

  @uId int,

  @sDate date,

  @eDate date

  AS

  BEGIN

  SET NOCOUNT ON;

  -- Insert statements for procedure here

  SELECT tblXYZ.uId, tblXYZ.aDate, tblXYZ.note

  FROM tblXYZ

  WHERE tblXYZ.uId = @uId

  AND tblXYZ.aDate >= @sDate

  AND tblXYZ.aDate <= @Date

  END

  When I run it, I am getting following error.

  Type mismatch.

  Please can someone help me.

  many thanks

  ASP Code

  <%

  myuId = 1

  mySDate = "'07/26/2010'"

  myEDate = "'07/31/2010'"

  objConn.Open CONN_STRING

  ' Create recordset and set the page size / Open RS

  Set RS = Server.CreateObject("ADODB.Recordset")

  RS.Open "Exec getStaffAppointment " & myStaffId, myStartDateUS, myEndDateUS,

  objConn

  %>

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  July 29, 2010 at 5:07 am

  #1199707

  RS.Open "Exec getStaffAppointment " & myStaffId, myStartDateUS, myEndDateUS,objConn

  Modify this line as below.

  RS.Open "Exec getStaffAppointment " & myStaffId & "," & myStartDateUS & "," & myEndDateUS,objConn

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga