Execute Stored Proc

Results 1 to 2 of 2

Thread: Execute Stored Proc

  1. #1
    Join Date
    Dec 1969

    Default Execute Stored Proc

    Hi, I&#039;m trying to execute a stored procedure in SQl 2000, The procedure returns a recordset, and I can&#039;t seem to get it to work, any ideas?<BR><BR>here is the code (Jscript)!<BR><BR>var sqlstr = "exec pGetPermissions @PUID = &#039;" + PUID + "&#039;";<BR>conn.Open(Application("PiData_Connect ionString"));<BR>rst3.Open(sqlstr,conn,3,3);<BR>Re sponse.Write(rst3("PermissionCode"));

  2. #2
    Join Date
    Dec 1969

    Default RE: Execute Stored Proc

    Seems something missing from your code (the part you posted anyways), try this,<BR><BR>(note: if PUID is integer, do not put single quotes around it)<BR><BR>var sqlstr = "exec pGetPermissions @PUID = &#039;" + PUID + "&#039;";<BR>conn.Open(Application("PiData_Connect ionString"));<BR>set rst3 = conn.execute(sqlstr)<BR>Response.Write rst3("PermissionCode");

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts