Samples - ASP JScript

Code Samples -- JScript
Example #2 - Sorting
<%@ Language=JScript %>
<%
var oConn = Server.CreateObject("OpenX2.Connection")
var oCommand = Server.CreateObject("OpenX2.Command")
var sResult = "";
var bError = false;
var sOrderBy = "au_lname";
if(Request.Form("newOrder").Count > 0)  {
  sOrderBy = Request.Form("newOrder");
}
var sSQL = "SELECT au_fname + ' ' + au_lname, phone, address, city, state, zip FROM authors order by " + sOrderBy;

try {
  var i;
  oConn.Connect("ms_ox1");
  oCommand.Connection = oConn;
  oCommand.CommandText = sSQL;
  oCommand.Execute();
  while(oCommand.MoveNext())  {
    sResult += "<tr>";
    for(i = 1; i <= oCommand.FieldCount; i++)  {
      sResult += "<td>" + oCommand.FieldValueAsString(i) + "</td>";
    }
    sResult += "</tr>";
  }
}
catch(e) {
  bError = true;
  if(oCommand.ErrorCode != 0)
    sResult = "OpenX2 Command Error: " + oCommand.ErrorInfo + ". Error #" + oCommand.ErrorCode + " (" + oCommand.ErrorCodeEx + ")<br />";
  else
    if(oConn.ErrorCode != 0)
      sResult += "OpenX2 Connection Error: " + oConn.ErrorInfo + ". Error #" + oConn.ErrorCode + " (" + oConn.ErrorCodeEx + ")<br />";

  sResult += "ASP Error: #" + e.number + ". " + e.description + "<br />";
}

%>

<html>
  <head><title>OpenX2 Test #2 - ORDER BY</title>
<script type="text/javascript" language="JavaScript">
<!--
var sCurOrder = "<%= sOrderBy %>";
function ChangeOrder(sNewOrder)
{
  if(sCurOrder != sNewOrder)  {
    reorder.newOrder.value = sNewOrder;
    reorder.submit();
  }
}

-->
</script>

</head>
  <body>
<%
if(bError)  {
%>
    <div><%=sResult%></div>
<%
}
else  {
%>
    Click on column caption to sort by it
    <form action="OX2test2.asp" method="post" name="reorder" id="reorder">
    <input type="hidden" name="newOrder" id="newOrder" value="au_lname">
    <table border="1">
      <tr>
      	<td style="cursor: hand;" onClick="ChangeOrder('au_lname')"><b>Name</b></td>
      	<td style="cursor: hand;" onClick="ChangeOrder('phone')"><b>Phone</b></td>
      	<td style="cursor: hand;" onClick="ChangeOrder('address')"><b>Address</b></td>
      	<td style="cursor: hand;" onClick="ChangeOrder('city')"><b>City</b></td>
      	<td style="cursor: hand;" onClick="ChangeOrder('state')"><b>State</b></td>
      	<td style="cursor: hand;" onClick="ChangeOrder('zip')"><b>Zip</b></td>
      </tr>
      <%=sResult%>
    </table>
    <form>
<%
}
%>
  </body>
</html>