home *** CD-ROM | disk | FTP | other *** search
- <% @ LANGUAGE="JScript" %>
-
- <!--#include file="adojavas.inc"-->
-
- <%
- // This example calls the ByRoyalty stored procedure
- // installed with the PUBS database with Microsoft SQL Server.
-
- // To run this sample, you must first do the following:
- //
- // 1) Go to the System Control Panel
- // 2) Open the OBDC Control Panel
- // 3) Select the System DSN Tab and Add a Source
- // 4) Choose the SQL Server Driver and hit Finish
- // 5) Name Source "IISSDK", enter name of the local server
- // 6) Setup Security (Note: If you have setup a password on the
- // SQL Server, you may have to change the example below)
- // 7) Set Default Database to the pubs db that comes with SQL
- %>
-
-
- <HTML>
- <HEAD>
- <TITLE>Using Stored Procedures</TITLE>
- </HEAD>
-
- <BODY bgcolor="white" topmargin="10" leftmargin="10">
-
- <!-- Display Header -->
-
- <font size="4" face="Arial, Helvetica">
- <b>Using Stored Procedures</b></font><p>
-
- <%
- var oConn;
- var oCmd;
- var oRs;
-
- oConn = Server.CreateObject("ADODB.Connection");
- oCmd = Server.CreateObject("ADODB.Command");
-
-
- // Open ADO Connection using account "sa"
- // and blank password
-
- oConn.Open("IISSDK", "sa", "");
- oCmd.ActiveConnection = oConn;
-
-
- // Setup Call to Stored Procedure and append parameters
-
- oCmd.CommandText = "{call byroyalty(?)}";
- oCmd.Parameters.Append(oCmd.CreateParameter("@Percentage", adInteger, adParamInput));
-
-
- // Assign value to input parameter
-
- oCmd("@Percentage") = 75;
-
-
- // Fire the Stored Proc and assign resulting recordset
- // to our previously created object variable
-
- oRs = oCmd.Execute();
- %>
-
- Author ID = <% Response.Write(oRs("au_id")) %><BR>
-
- </BODY>
- </HTML>
-