ActualSize and DefinedSize Properties Example (JScript)

This example uses the ActualSize and DefinedSize properties to display the defined size and actual size of a field. Cut and paste the following code to Notepad or another text editor, and save it as ActualSizeJS.asp.

<!-- BeginActualSizeJS -->
<%@LANGUAGE="JScript" %>
<%// use this meta tag instead of adojavas.inc%>
<!--METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" -->
<html>

<head>
    <title>ActualSize and DefinedSize Properties Example (JScript)</title>
<style>
<!--
body {
   font-family: 'Verdana','Arial','Helvetica',sans-serif;
   BACKGROUND-COLOR:white;
   COLOR:black;
    }
.thead2 {
   background-color: #800000; 
   font-family: 'Verdana','Arial','Helvetica',sans-serif; 
   font-size: x-small;
   color: white;
   }
.tbody { 
   text-align: center;
   background-color: #f7efde;
   font-family: 'Verdana','Arial','Helvetica',sans-serif; 
   font-size: x-small;
    }
-->
</style>
</head>

<body bgcolor="White">

<h1>ADO ActualSize and DefinedSize Properties (JScript)</h1>
<%
    // connection and recordset variables
    var Cnxn = Server.CreateObject("ADODB.Connection")
    var strCnxn = "Provider='sqloledb';Data Source=" + Request.ServerVariables("SERVER_NAME") + ";" +
            "Initial Catalog='Northwind';Integrated Security='SSPI';";
    var rsSuppliers = Server.CreateObject("ADODB.Recordset");
    // display variables
    var fld, strMessage;        
    
    try
    {
        // open connection
        Cnxn.Open(strCnxn);
    
        // Open a recordset on the stores table    
        rsSuppliers.Open("Suppliers", strCnxn);
    
        // build table headers
        Response.Write("<table>");
        Response.Write('<tr class="thead2"><th>Field Value</th>');
        Response.Write("<th>Defined Size</th>");
        Response.Write("<th>Actual Size</th></tr>");
            
        while (!rsSuppliers.EOF)
        {
            // start a new line
            strMessage = '<tr class="tbody">';
                    
            // Display the contents of the chosen field with
            // its defined size and actual size
            fld = rsSuppliers("CompanyName");
            strMessage += '<td align="left">' + fld.Value + "</td>" 
            strMessage += "<td>" + fld.DefinedSize + "</td>";
            strMessage += "<td>" + fld.ActualSize + "</td>";
                    
            // end the line
            strMessage += "</tr>";
                
            // display data
            Response.Write(strMessage);
                    
            // get next record
            rsSuppliers.MoveNext;

        }
         // close the table
        Response.Write("</table>");
    }
    catch (e)
    {
        Response.Write(e.message);
    }
    finally
    {
        // clean up
        if (rsSuppliers.State == adStateOpen)
            rsSuppliers.Close;
        if (Cnxn.State == adStateOpen)
            Cnxn.Close;
        rsSuppliers = null;
        Cnxn = null;
    }
%>

</body>

</html>
<!-- EndActualSizeJS -->

ActualSize and DefinedSize Properties Example (JScript)

See Also