PDA

View Full Version : Integrate jscript web page with MS Access



austenr
08-18-2007, 06:33 PM
This one is out of my league. What I have is the following:

I have a jscript web page that has a search box on it. Depending on what is entered, the script needs to open a connection to the DB, look for the search string and return fields from an Access table. My only exposure to jscript is applets on a web page (not writing them, just incorporating them into web pages). I'm doing this as part of a contract job and have a week to come up with a solution. I'm getting an insane rate on this so if this is your area of expertise I can shoot you some paypal money. :help:beg:

stanl
08-19-2007, 05:03 AM
Seems the web page form would have a submit button [or something similar]. Just follow the link and set up an HTTP Request and parse the return values. Stan

[I'm in Raleigh, NC so if you need more info, contact me privately]

austenr
08-19-2007, 09:13 AM
Here is the shell page minus the css:

<!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>ETG: Product Listing</title>
<link rel="stylesheet" href="etg.css" type="text/css" />
<link rel="stylesheet" href="jsearch_jm.css"/>
<script language="javascript">AC_FL_RunContent = 0;</script>
<script src="AC_RunActiveContent.js" language="javascript"></script>
</head>

<body class="etg">
<div id="wrapper">
<div id="container">


<div id="header" style="background:
url(images/projectsbanner.jpg) no-repeat;">
</div>

<div id="nav2">
<table width="870" cellspacing="0" cellpadding="0" border="1"><tr>
<td colspan="2" valign="top" height="110" nowrap >
<img src="images/HBS-shield-100yrs.gif"
width="133" height="106" align="top"
style="padding-top: 0px; padding-bottom:
6px;"></td>
<td colspan="4">
<map name="HomeMap">
<area coords="366,61 716,88" shape="rect" href="index.html">
<area coords="552,94 716,111"
shape="rect" href="http://www.hbs.edu/it">
</map>
<img src="images/spacer.gif"
usemap="#HomeMap" width="715" height="110"
border="0">
</td>
</tr>
<tr>
<td width="30"><img src="images/spacer.gif"
width="20" height="20" border="0"></td>
<td width="110"><a href="what.html">What we do</a></td>
<td width="110"><a href="showcase.html">Showcase</a></td>
<td width="130"><a href="projects.html"><span
class="current">Project Index</span></a></td>
<td width="190"><a href="team.html">Meet the Team</a></td>
<td width="200" align="right" valign="bottom"
nowrap style="padding-left: 10px;">
<form method='get' action='/bb/search/query.asp'>
<input type='text' size='25' maxlength='80' value='' >&nbsp; &nbsp;
<input type='submit' class='formtext' value='Search' ></form></td>
</tr>
<tr>
<td><img src="images/spacer.gif" width="30" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="120" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="100" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="120" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="120" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="220" height="1" border="0"></td>
</tr>
</table>
</div>

<div id="mainContent">

<h2>Project Detail</h2>

<!-- COURSEWARE CATALOG GOES HERE -->
<div id="searchcontainer" style="display: block; width: 160px;">

<p>Filter by:</p>
<div><a href="#"
onclick="doListExpand(2);return
false">Type</a><ul></ul></div>
<div><a href="#"
onclick="doListExpand(3);return false">Tech
Format</a><ul></ul></div>
<div><a href="#"
onclick="doListExpand(6);return false">Faculty
Sponsor</a><ul></ul></div>
<div><a href="#"
onclick="doListExpand(7);return false">Faculty
Unit</a><ul></ul></div>
<div><a href="#"
onclick="doListExpand(8);return false">Year
Created</a><ul></ul></div>
<div><a href="#"
onclick="doListExpand(9);return
false">Program</a><ul></ul></div>
<span>Courseware #:</span><form
onsubmit="doNumSearch(this);return false"><input
name="s" size="20" type="text">&nbsp;&nbsp;<input
value="Go" type="submit"></form>
</div>


<div id="listcontainer">

<div id="cmsection">
<table><tbody>
<tr>
<td class="ccol">Title:</td>
<td class="dcol"><p>Beer Game University</p></td></tr>
<tr>
<td class="ccol">URL:</td>
<td class="dcol"><p><a
href="http://courseware.hbs.edu/tutorials/bgu/"
target="_new">http://courseware.hbs.edu/tutorials/bgu/</a></p></td></tr>
<tr>
<td class="ccol">Type:</td>
<td class="dcol"><p>Tutorial <a
class="backlink symbol" href="#"
onclick="doInfoConstrain(8,2,0);return
false">’??</a></p></td></tr>
<tr>
<td class="ccol">Tech Format:</td>
<td class="dcol"><p>Web <a
class="backlink symbol" href="#"
onclick="doInfoConstrain(8,3,0);return
false">’??</a></p></td></tr>
<tr>
<td class="ccol">Subject / Topic:</td>
<td class="dcol"><p>Supply Chain Management</p></td></tr>
<tr>
<td class="ccol">Created For:</td>
<td class="dcol"><p>Technology &amp;
Operations Management</p></td></tr>
<tr>
<td class="ccol">Faculty Sponsor:</td>
<td class="dcol"><p>Upton, David <a
class="backlink symbol" href="#"
onclick="doInfoConstrain(8,6,0);return
false">’??</a>, McAfee, Andrew <a class="backlink
symbol" href="#"
onclick="doInfoConstrain(8,6,1);return
false">’??</a></p></td></tr>
<tr>
<td class="ccol">Faculty Unit:</td>
<td class="dcol"><p>Technology and
Operations Management <a class="backlink symbol"
href="#" onclick="doInfoConstrain(8,7,0);return
false">’??</a></p></td></tr>
<tr>
<td class="ccol">Year Created:</td>
<td class="dcol"><p>2004 <a
class="backlink symbol" href="#"
onclick="doInfoConstrain(8,8,0);return
false">’??</a></p></td></tr>
<tr>
<td class="ccol">Program:</td>
<td class="dcol"><p>RC <a
class="backlink symbol" href="#"
onclick="doInfoConstrain(8,9,0);return
false">’??</a></p></td></tr>
<tr>
<td class="ccol">HBS Production Team:</td>
<td class="dcol"><p>HBS Information Technology Group</p></td></tr>
<tr>
<td class="ccol">URL to Documentation:</td>
<td class="dcol"><p><a
href="http://isites.hbs.edu/pages/9543/beer/index_beer.html"
target="_new">Available to Faculty and Staff
Only</a></p></td></tr>
<tr>
<td class="ccol">Description:</td>
<td class="dcol"><p>This is a website
with video clips and screen captures and is meant
to provide an overview for faculty and staff who
support and administer the game. This site is not
available to students nor should any information
on this site be distributed to them. The learning
points of the exercise will be compromised by the
information contained in these video and
application screencapture clips.</p></td></tr>
</tbody></table>

<p>Click an <span
style="color:#900;">’??</span> to find similar
items.</p>
<p><br><a class="backlink" href="#"
onclick="window.history.back();return
false">Back</a></p></div>

<br><br><br><br><br><br>
<!-- end #mainContent --></div>

<div id="footer">
<p><a href="" target="_new">We are located
off campus at 25 travis Street</a> &nbsp;|
&nbsp;<a href="glossary.html"
target="_new">education technology glossary</a>
&nbsp;| &nbsp;<a
href="mailto:ctishler@hbs.edu?subject=ETG project
inquiry">email us with questions or project
ideas</a></p>
<!-- end #footer --></div>
<!-- end #container --></div>
<!-- end of #wrapper --></div>



</body>
</html>