I have an HTA which loads in a large table into HTML. However, I want to take advantage of the jquery plugin for Datatables. However, when i got to run my script it gets an script error at line : <script language="javascript" src="https://code.jquery.com/jquery-3.3.1.js"></script>
which makes me think I am not implementing jquery correctly. From all the post I have seen javascript files seem to be loaded in this way even for HTAs. It also takes quite a bit to load the 15000 rows so once Datatables is implemented and there is pagination then shouldnt the load time be reduced?
<!DOCTYPE html>
<html lang="en-US">
<style>
</style>
<head>
<title>ARMS Hamburger Site</title>
<meta charset="UTF-8">
<meta http-equiv="x-ua-compatible" content="ie=9">
<meta name="viewport" content="width=device-width, initial-scale=1">
<script language="javascript" src="https://code.jquery.com/jquery-3.3.1.js"></script>
<script language="javascript" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">
</head>
<body>
<script language="javascript">
var today = new Date();
var t0 = today.getSeconds();
var connection = new ActiveXObject("ADODB.Connection") ;
var rs = new ActiveXObject("ADODB.Recordset");
var connectionstring="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\\\path.accdb;Jet OLEDB:Engine Type=5;Persist Security Info=False;Mode=Share Exclusive;"
connection.CursorLocation=3;
connection.Mode=3;
connection.Open(connectionstring);
rs.Open("SELECT * FROM table", connection);
var str=rs.GetString(2,rs.RecordCount,"</td><td>","</td></tr><tr><td>"," ");
rs.close;
connection.close;
</script>
<center>
<table id="myTable" class="display" style="width:100%">
<tr>
<td><script language="javascript">document.write(str)</script></td>
</tr>
</table>
</center>
</body>
</html>
<script language="javascript">
$(document).ready(function() {
$('#myTable').DataTable();
} );
</script>