ActiveCommand Property Example (JScript)

This example demonstrates the ActiveCommand property. Cut and paste the following code to Notepad or another text editor, and save it as ActiveCommandJS.asp.
<!-- BeginActiveCommandJS -->
<%@LANGUAGE="JScript" %>
<%// use this meta tag instead of adojavas.inc%>
<!--METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" -->

<%
   // user input
   strName = new String(Request.Form("ContactName"))
%>

<html>

<head>
<title>ActiveCommand Property Example (JScript)</title>
<style>
<!--
BODY {
   font-family: 'Verdana','Arial','Helvetica',sans-serif;
   BACKGROUND-COLOR:white;
   COLOR:black;
    }
-->
</style>
</head>

<body bgcolor="White">

<h1>ActiveCommand Property Example (JScript)</h1>

<%
   if (strName.length > 0)
   {
      // connection and recordset variables
      var Cnxn = Server.CreateObject("ADODB.Connection")
      var strCnxn = "Provider=sqloledb;Data Source=" + Request.ServerVariables("SERVER_NAME")+ ";" +
         "Initial Catalog=Northwind;User Id=sa;Password=;"
      var cmdContact = Server.CreateObject("ADODB.Command");
      var rsContact = Server.CreateObject("ADODB.Recordset");
      // display variables
      var strMessage
   
      // open connection
      Cnxn.Open(strCnxn);

      // Open a recordset using a command object
      cmdContact.CommandText = "SELECT ContactName FROM Customers WHERE City = ?";
      cmdContact.ActiveConnection = Cnxn;
      // create parameter and insert variable value
      cmdContact.Parameters.Append(cmdContact.CreateParameter("ContactName", adChar, adParamInput, 30, strName));
      
      rsContact = cmdContact.Execute();

      while(!rsContact.EOF){
         // start new line
         strMessage = "<P>";
            
         // get data
         strMessage += rsContact("ContactName")
            
         // end the line
         strMessage += "</P>";
         
         // show data
         Response.Write(strMessage);
            
         // get next record
         rsContact.MoveNext;
      }
   
      // clean up
      rsContact.Close;
      Cnxn.Close;
   }
%>

<hr>


<form method="POST" action="ActiveCommandJS.asp">
  <p align="left">Enter city of customer to find (e.g., Paris): <input type="text" name="ContactName" size="40" value=""></p>
  <p align="left"><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
</body>

</html>
<!-- EndActiveCommandJS -->
ActiveCommand Property Example (JScript)

See Also
