<%@ Transaction="Required" LANGUAGE="JSCRIPT" %>
<%
// Access Provider
// NOTE: UID and PWD syntax cannot be used here
Response.Buffer = true;
var conn = Server.CreateObject( "ADODB.Connection" );
conn.Open( "PROVIDER=Microsoft.Jet.OLEDB.3.51;" +
"DATA SOURCE=d:/inetpub/wwwroot/xmop/xmop-signup.mdb;" +
"USER ID=;PASSWORD=;");
var rs = Server.CreateObject("ADODB.Recordset");
rs.Open("signup",conn,adOpenKeyset,adLockOptimistic,adCmdTable);
while (!rs.EOF) {
%>
| <%= rs("LastName") %> | <%= rs("E-mail") %> |
%<
//var oxml = ObjectContext.CreateObject("JABR.XMLRS");
//oxml.AutoFormat(rs);
//oxml.DTD = false;
//oxml.DocType = "Testers";
//oxml.ItemName = "Tester";
//oxml.OutputHeader = false;
//oxml.AutoFormat(rs);
rs.MoveNext();
};
%>
<%
ObjectContext.SetComplete();
//oxml = null;
rs = null;
conn = null;
function OnTransactionCommit()
{
// Response.ContentType = "text/xml";
};
// The Transacted Script Abort Handler. This sub-routine
// will be called if the script transacted aborts
function OnTransactionAbort()
{
Response.Write("Error accessing database
");
};
};
%>