Problems connecting to Access 2007 database with JavaScript
I am trying to create a form that will generate a query, send that query to a database, and display the results on a Web page. For now, the form fields don't actually contribute anything to the code, they just sit there as placeholders. What I want to do for now is this: connect the page to the database, run a hard-coded query, and have the results displayed in table form on the page. I want the database to be a .accdb (Access 2007) file that is located on the server. I have been using JavaScript to do this.
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>School of CIS TCPT</title>
<script language="JavaScript" >
function getSubmit()
{
var ClassID;
var CreditHours;
var cn = new ActiveXObject("ADODB.Connection");
var strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source = classes.accdb;Persist Security Info=False";
var rs = new ActiveXObject("ADODB.Recordset");
var SQL = "SELECT 0910.ClassID, 0910.CreditHours FROM 0910";
var resultSet = strConn.query(SQL);
cn.Open(strConn);
rs.Open(SQL, cn);
ClassID.value = rs(0);
CreditHours.value = rs(1);
rs.Close();
cn.Close();
}
</script>
<link href="style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style2 {color: #c80000}
-->
</style>
</head>
<body>
<input type="button" value="Get count" onclick="getCount()">
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0" class="bodystyle">
<tr>
<td class="header"><p align="center">School of Computer and Information Sciences Advising System <span class="style2">Transfer Course Plan Tool</span></p> </td>
</tr>
<tr>
<td height="10"> </td>
</tr>
<tr>
<td>Use the form below to enter your information and preferences, then click "Submit" to generate a course plan. Fields with an asterisk are required.</td>
</tr>
<tr>
<td height="10"> </td>
</tr>
<tr>
<td><table width="615" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="35" colspan="2">* Bulletin:
<select name="bulletin" id="bulletin" tabindex="1">
<option selected="selected" disabled="disabled">Select Bulletin Year</option>
<option value="0910">2009-2010</option>
<option value="1011" disabled="disabled">2010-2011</option>
</select> </td>
<td width="340" height="35">* Starting Semester:
<select name="semester" id="semester" tabindex="2">
<option selected="selected" disabled="disabled">Select Semester</option>
<option value="fall">Fall</option>
<option value="spring">Spring</option>
</select></td>
</tr>
<tr>
<td height="35" colspan="2">* Major:
<label>
<select name="major" id="major" tabindex="3">
<option selected="selected" disabled="disabled">Select Major</option>
<option value="cs" disabled="disabled">Computer Science</option>
<option value="is" disabled="disabled">Information Science</option>
<option value="it">Information Technology</option>
</select>
</label></td>
<td height="35">* Select Concentration:
<label>
<select name="concentration" id="concentration" tabindex="4">
<option selected="selected" disabled="disabled">Select Concentration</option>
<option value="data" disabled="disabled">Data Management</option>
<option value="web">Web Publishing</option>
<option value="networking" disabled="disabled">Networking</option>
<option value="forensics" disabled="disabled">Digital Forensics</option>
</select>
</label></td>
</tr>
<tr>
<td width="150" height="35">* Are you Calculus ready? </td>
<td width="125" height="35"><form id="form1" name="form1" method="post" action="">
<label>
<input type="radio" name="radio" id="calcready" value="yes" tabindex="5" />Yes </label> <label>
<input type="radio" name="radio" id="calcready" value="no" tabindex="6" />No
</label>
</form></td>
<td height="35">Preferred Hours per Semester:
<label>
<select name="hours" id="hours" tabindex="7">
<option selected="selected" disabled="disabled">Select Hours</option>
<option value="parttime">>12 (Part Time)</option>
<option value="regfulltime">12 - 15 (Full Time)</option>
<option value="extrafulltime">16+ (Full Time)</option>
</select>
</label></td>
</tr>
<tr>
<td height="35" colspan="3"><div align="center">
<input type="reset" name="reset" id="reset" value="Reset" accesskey="R" tabindex="9" />
<label>
<input type="button" value="Submit" accesskey="S" tabindex="10" onclick="getSubmit()" />
</label>
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</body>
</html>
I have tried adding things like "alert("test");" etc. to the Submit button just to see if the code was working. No dice. I click on the button, and nothing happens. So I tried creating a little "document.write("Hello World!");" to see if JavaScript itself was even working, and the Hello World DID work. So obviously, something is wrong with my code.
Hi,
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Reply With Quote
Bookmarks