Update multiple records from table in classic ASP
Hey Experts!!
I am doing an internal application with simple add, update, delete functions.
My ASP outputs the HTML below. Each row is a different record. What I need to do is be able to have someone select a radio button in one or multiple rows and then click on update and have it update via AJAX.
I have done AJAX before on a couple of the other pages, however I'm not sure how to write the SQL for this or to setup the form.
All help and suggestions are appreciated.
I am doing an internal application with simple add, update, delete functions.
My ASP outputs the HTML below. Each row is a different record. What I need to do is be able to have someone select a radio button in one or multiple rows and then click on update and have it update via AJAX.
I have done AJAX before on a couple of the other pages, however I'm not sure how to write the SQL for this or to setup the form.
All help and suggestions are appreciated.
Dave Baldwin
I don't see the HTML output...
ASKER
Completely forgot to post it. Here it is now.
<!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>
<link href="/css/reset.css" rel="stylesheet" type="text/css" />
<link href="/css/main.css" rel="stylesheet" type="text/css" />
<link href="css/smoothness/jquery-ui-1.8.15.custom.css" rel="stylesheet" type="text/css"/>
<link href="css/tipTip.css" rel="stylesheet" type="text/css" />
<link href="css/ColReorder.css" rel="stylesheet" type="text/css" />
<title>Idea Center :: Admin</title>
</head>
<body>
<div id="header">
<a href="/">
<img src="../images/TMC-logo-new1.jpg" alt="logo" title="logo" />
</a>
<h1> Connection </h1>
<a id="account" href="https://www.lookupmyloan.com/gserv/dbweb.asp?ac=G1&TM" target="_blank"> Account Info </a>
</div><!--end header-->
<div id="wrapper">
<div id="ideaHeader">
<div id="logo">
<a href="index.asp">
<img src="images/lighbulb-USD-50.png" />
<h1>dea Connection</h1>
</a>
</div>
<a class="button admin" href="test1.asp">Admin</a>
<a id="legendHandle" class="button" href="#">Legend </a>
<div id="legend">
<ul>
<li><img src="images/smNew.png" /> <span> - New Idea </span></li>
<li><img src="images/smThumbUp.png" /> <span> - Continue Idea</span></li>
<li><img src="images/smThumbDown.png" /> <span> - Stop Idea </span></li>
</ul>
</div>
</div><!--end header -->
<div id="container" class="table">
<form method="post" action="addDelete.asp" class="table">
<table width="100%" border="0" cellspacing="2" cellpadding="2" class="" id="admin">
<thead>
<tr>
<th width="15%">Update Status</th>
<th width="6%">Date </th>
<th width="8%"> Status</th>
<th width="11%">Name</th>
<th width="20%">Title</th>
<th width="40%">Idea </th>
</tr>
</thead>
<tbody>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus44" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus44" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus44" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>John Doe</td>
<td>
<a href="ideaEdit.asp?id=44" class="link ideaTitle" title="New Idea">
New Idea
</a>
</td>
<td>Here's a great new idea for Towne Mortgage.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus45" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus45" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus45" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>John Doe</td>
<td>
<a href="ideaEdit.asp?id=45" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus46" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus46" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus46" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>John Doe</td>
<td>
<a href="ideaEdit.asp?id=46" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus49" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus49" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus49" VALUE="future" />Future
</label>
</div>
</td>
<td>8/29/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>LZ</td>
<td>
<a href="ideaEdit.asp?id=49" class="link ideaTitle" title="Another bad idea">
Another bad idea
</a>
</td>
<td>Just another bad idea. I'm really wanting and needing ...</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus53" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus53" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus53" VALUE="future" />Future
</label>
</div>
</td>
<td>8/25/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>John Doe again</td>
<td>
<a href="ideaEdit.asp?id=53" class="link ideaTitle" title="Just another test">
Just another test
</a>
</td>
<td>This time let's make sure we go beyond the 50 character...</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus54" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus54" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus54" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>Maria</td>
<td>
<a href="ideaEdit.asp?id=54" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus55" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus55" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus55" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>Bill</td>
<td>
<a href="ideaEdit.asp?id=55" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus56" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus56" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus56" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>Roberta</td>
<td>
<a href="ideaEdit.asp?id=56" class="link ideaTitle" title="New Idea">
New Idea
</a>
</td>
<td>Here's a great new idea for Towne Mortgage.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus57" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus57" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus57" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>Mike</td>
<td>
<a href="ideaEdit.asp?id=57" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus58" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus58" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus58" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>Rick</td>
<td>
<a href="ideaEdit.asp?id=58" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus59" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus59" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus59" VALUE="future" />Future
</label>
</div>
</td>
<td>8/25/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>Shelly</td>
<td>
<a href="ideaEdit.asp?id=59" class="link ideaTitle" title="Just another test">
Just another test
</a>
</td>
<td>This time let's make sure we go beyond the 50 character...</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus60" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus60" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus60" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>Maryann</td>
<td>
<a href="ideaEdit.asp?id=60" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus61" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus61" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus61" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>Tom</td>
<td>
<a href="ideaEdit.asp?id=61" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus62" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus62" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus62" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>Amanda</td>
<td>
<a href="ideaEdit.asp?id=62" class="link ideaTitle" title="New Idea">
New Idea
</a>
</td>
<td>Here's a great new idea for Towne Mortgage.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus63" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus63" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus63" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>Christina </td>
<td>
<a href="ideaEdit.asp?id=63" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus64" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus64" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus64" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>John</td>
<td>
<a href="ideaEdit.asp?id=64" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus65" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus65" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus65" VALUE="future" />Future
</label>
</div>
</td>
<td>8/25/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>Carol</td>
<td>
<a href="ideaEdit.asp?id=65" class="link ideaTitle" title="Just another test">
Just another test
</a>
</td>
<td>This time let's make sure we go beyond the 50 character...</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus66" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus66" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus66" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>Kathy</td>
<td>
<a href="ideaEdit.asp?id=66" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus67" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus67" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus67" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>Olivia</td>
<td>
<a href="ideaEdit.asp?id=67" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus68" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus68" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus68" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>Jack</td>
<td>
<a href="ideaEdit.asp?id=68" class="link ideaTitle" title="New Idea">
New Idea
</a>
</td>
<td>Here's a great new idea for Towne Mortgage.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus69" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus69" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus69" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>Brent</td>
<td>
<a href="ideaEdit.asp?id=69" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus70" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus70" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus70" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>Chris</td>
<td>
<a href="ideaEdit.asp?id=70" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus71" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus71" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus71" VALUE="future" />Future
</label>
</div>
</td>
<td>8/25/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>John Doe again</td>
<td>
<a href="ideaEdit.asp?id=71" class="link ideaTitle" title="Just another test">
Just another test
</a>
</td>
<td>This time let's make sure we go beyond the 50 character...</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus72" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus72" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus72" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>John Doe</td>
<td>
<a href="ideaEdit.asp?id=72" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus73" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus73" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus73" VALUE="future" />Future
</label>
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>John Doe</td>
<td>
<a href="ideaEdit.asp?id=73" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
</tbody>
</table>
<div id="buttons">
<input name="Submit" type="submit" class="submit button stop" value="Update" id="submit">
<input name="Reset" type="reset" class="reset button" value="Cancel" id="reset">
</div>
</form>
</div><!--end container -->
</div><!--end wrapper -->
<div id="sticky-footer-push"> </div>
</div><!--end wrapper -->
<div id="footer">
© 2011 Towne Mortgage
</div><!--end footer-->
<script type="text/javascript" src="includes/jquery-1.6.2.min.js"> </script>
<script type="text/javascript" src="includes/jquery-ui-1.8.15.custom.min.js"></script>
<script type="text/javascript" src="includes/jquery.dialogextend.min.js"></script>
<script type="text/javascript" src="includes/inputReplace.js"></script>
<script type="text/javascript" src="includes/jquery.tipTip.minified.js"> </script>
<script type="text/javascript" src="includes/dataTables.js"> </script>
<script type="text/javascript" src="includes/ColReorder.js"> </script>
<script type="text/javascript">
$(document).ready(function() {
positionFooter();
$(window)
.scroll(positionFooter)
.resize(positionFooter);
function positionFooter() {
var docHeight = $(document.body).height() - $("#sticky-footer-push").height();
if(docHeight < $(window).height()){
var diff = $(window).height() - docHeight;
if (!$("#sticky-footer-push").length > 0) {
$("#footer").before('<div id="sticky-footer-push"></div>');
}
$("#sticky-footer-push").height(diff);
}
}
});
</script>
<script type="text/javascript">
jQuery(function( $ ){
var container = $( "#legend" );
$( "#legendHandle" ).click(
function( event ){
event.preventDefault();
if (container.is( ":visible" )){
container.hide("slide", {direction:"up" }, 1000);
} else {
container.show("slide", {direction:"up" }, 1000);
}
}
);
});
</script>
<script type="text/javascript">
$(document).ready(function() {
$(function(){
$(".help").tipTip({delay:100});
});
});
</script>
<script type="text/javascript">
$(document).ready(function () {
$('.link').live('click', function (e) {
e.preventDefault();
var page = $(this).attr("href")
var pagetitle = $(this).attr("title")
var $dialog = $('<div></div>')
.html('<iframe style="border: 0px;overflow:hidden; " src="' + this + '" width="100%" height="100%" frameBorder="0"></iframe>')
.dialog({
autoOpen: false,
modal: false,
height: 560,
width: 540,
maximize:true,
minimize:true,
position: ['center','top'],
title: pagetitle
//show: "bounce"
})
.dialogExtend({
"maximize" : true,
"dblclick" : "maximize",
"icons" : {
"maximize" : "ui-icon-extlink",
"restore" : "ui-icon-newwin"
}
});
$dialog.dialog('open');
});
});
</script>
<script type="text/javascript">
$(document).ready(function(){
$(".stripeMe tr").mouseover(function(){$(this).addClass("over");}).mouseout(function(){$(this).removeClass("over");});
$(".stripeMe tr:even").addClass("alt");
});
</script>
<script type="text/javascript">
/*<!-- Begin
var checkflag = "false";
function check(field) {
if (checkflag == "false") {
for (i = 0; i < field.length; i++) {
field[i].checked = true;
}
checkflag = "true";
return "Uncheck All";
} else {
for (i = 0; i < field.length; i++) {
field[i].checked = false;
}
checkflag = "false";
return "Check All";
}
}}
// End -->
*/
</script>
<!--Row highlighting and clicking -->
<script type="text/javascript">
$(document).ready(function() {
$('#admin tr')
.filter(':has(:checkbox:checked)')
.addClass('highlight')
.end()
.click(function(event) {
$(this).toggleClass('highlight');
});
});
</script>
<!--DataTable Functions -->
<script type="text/javascript">
$(document).ready(function() {
$('#admin').dataTable( {
"aaSorting": [[ 4, "desc" ]],
"sDom": 'Rlfrtip',
"bStateSave":true,
"sPaginationType": "full_numbers"
});
});
</script>
<script type="text/javascript">
$("button").click(function () {
$(".ui-dialog-titlebar-close").remove($dialog);
});
</script>
</body>
</html>
maybe this will help you http://www.tizag.com/ajaxTutorial/ajax-mysql-database.php
ASKER
@godeschalk: I'm sorry but that's not even close to what I need. I'm looking for help with the SQL statement for my Classic ASP/VBScript application. I know how to call the AJAX function, but the "UPDATE" statement is where I'm getting lost.
but the update is being done asp/vb
like
conn.execute("UPDATE table_name SET column1=value, column2=value2,... WHERE some_column=some_value")
like
conn.execute("UPDATE table_name SET column1=value, column2=value2,... WHERE some_column=some_value")
here is a nice website about it http://www.w3schools.com/sql/sql_update.asp
ASKER
What about when I have multiple rows and I'm updating one column? How would that SQL look?
Your code doesn't show *how* you are using the checkbox. It doesn't even show it, period.
But, I am assuming that you are going to be pulling your records from the db.
If yes, then: you query your db for the all the records on the db:
SQL = "SELECT * from yourtable"
set rs=con.execute(SQL)
Then your form should look similar to this:
<form name="multipleDeletes" action="deleteMultiple.asp
Next, is the checkbox that I don't see in your markup:
<input type='checkbox' name='checkUncheck' onClick='this.value=check(
Rest of markup code
On deleteMultiple.asp page, you want to declare a comma-separated var for holding the items you want to delete.
Makes sense?
You just need to fix your html to show how your ajax and update and delete markups work.
But, I am assuming that you are going to be pulling your records from the db.
If yes, then: you query your db for the all the records on the db:
SQL = "SELECT * from yourtable"
set rs=con.execute(SQL)
Then your form should look similar to this:
<form name="multipleDeletes" action="deleteMultiple.asp
Next, is the checkbox that I don't see in your markup:
<input type='checkbox' name='checkUncheck' onClick='this.value=check(
Rest of markup code
On deleteMultiple.asp page, you want to declare a comma-separated var for holding the items you want to delete.
strmultipleDeleteList = Request("multipleDelete")
'Ensure something is selected
if strmultipleDeleteList = "" then
'No items to update or delete
Response.Write "You did not select any items to update or delete!"
Else
'Now either delete or update
'Now, use the SQL set notation to archive all of the records specified by strmultipleDeleteList
Dim strSQL
strmultipleDeleteList = Replace( strmultipleDeleteList , ", ", "','" ) 'comma-separated list
If Trim(Request.Form("EDIT")) = "Update" Then
' save changes to existing records
strSQL = "Update YourTable set fieldname='var' " & _
"WHERE ID IN ('" & strmultipleDeleteList & "')"
'response.write strsql
'response.end
rs.Open strSQL, objConn
ElseIf Trim(Request.Form("DELETE")) = "Delete" Then
strSQL = "DELETE FROM YourTable" & _
"WHERE ID IN ('" & strmultipleDeleteList & "')"
'response.write strsql
'response.end
rs.Open strSQL, objConn
'Clean up
objConn.Close
Set objConn = NothingMakes sense?
You just need to fix your html to show how your ajax and update and delete markups work.
ASKER
@sammySeltzer:There were no checkboxes, but rather radio buttons. Each row in the table will have 3 radio buttons, which have different values. The goal is to have the user click on any given amount(whether it be 1, 2 5, or 25) of radio buttons, hit submit and update all of those records.
Here is the HTML source:
And here is the ideaUpdate.asp that I'm calling in the Jquery/AJAX function:
Here is the HTML source:
<!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>
<link href="/css/reset.css" rel="stylesheet" type="text/css" />
<link href="/css/main.css" rel="stylesheet" type="text/css" />
<link href="css/smoothness/jquery-ui-1.8.15.custom.css" rel="stylesheet" type="text/css"/>
<link href="css/tipTip.css" rel="stylesheet" type="text/css" />
<link href="css/ColReorder.css" rel="stylesheet" type="text/css" />
<title>Idea Center :: Admin</title>
</head>
<body>
<div id="header">
<a href="/">
<img src="../images/TMC-logo-new1.jpg" alt="logo" title="logo" />
</a>
<h1> Towne Connection </h1>
<a id="account" href="https://www.lookupmyloan.com/gserv/dbweb.asp?ac=G1&TM" target="_blank"> Account Info </a>
</div><!--end header-->
<div id="wrapper">
<div id="ideaHeader">
<div id="logo">
<a href="index.asp">
<img src="images/lighbulb-USD-50.png" />
<h1>dea Connection</h1>
</a>
</div>
<a class="button admin" href="test1.asp">Admin</a>
<a id="legendHandle" class="button" href="#">Legend </a>
<div id="legend">
<ul>
<li><img src="images/smNew.png" /> <span> - New Idea </span></li>
<li><img src="images/smThumbUp.png" /> <span> - Continue Idea</span></li>
<li><img src="images/smThumbDown.png" /> <span> - Stop Idea </span></li>
</ul>
</div>
</div><!--end header -->
<div id="container" class="table">
<form method="post" action="" class="table" id="adminUpd">
<table width="100%" border="0" cellspacing="2" cellpadding="2" class="" id="admin">
<thead>
<tr>
<th width="15%">Update Status</th>
<th width="6%">Date </th>
<th width="8%"> Status</th>
<th width="11%">Name</th>
<th width="20%">Title</th>
<th width="40%">Idea </th>
</tr>
</thead>
<tbody>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus44" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus44" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus44" VALUE="future" />Future
</label>
<input type="hidden" value="44" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>Lenny</td>
<td>
<a href="ideaEdit.asp?id=44" class="link ideaTitle" title="New Idea">
New Idea
</a>
</td>
<td>Here's a great new idea for Towne Mortgage.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus45" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus45" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus45" VALUE="future" />Future
</label>
<input type="hidden" value="45" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>Lenny</td>
<td>
<a href="ideaEdit.asp?id=45" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus46" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus46" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus46" VALUE="future" />Future
</label>
<input type="hidden" value="46" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>Lenny</td>
<td>
<a href="ideaEdit.asp?id=46" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus49" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus49" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus49" VALUE="future" />Future
</label>
<input type="hidden" value="49" name="id" />
</div>
</td>
<td>8/29/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>LZ</td>
<td>
<a href="ideaEdit.asp?id=49" class="link ideaTitle" title="Another bad idea">
Another bad idea
</a>
</td>
<td>Just another bad idea. I'm really wanting and needing ...</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus53" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus53" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus53" VALUE="future" />Future
</label>
<input type="hidden" value="53" name="id" />
</div>
</td>
<td>8/25/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>Lenny again</td>
<td>
<a href="ideaEdit.asp?id=53" class="link ideaTitle" title="Just another test">
Just another test
</a>
</td>
<td>This time let's make sure we go beyond the 50 character...</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus54" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus54" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus54" VALUE="future" />Future
</label>
<input type="hidden" value="54" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>Maria</td>
<td>
<a href="ideaEdit.asp?id=54" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus55" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus55" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus55" VALUE="future" />Future
</label>
<input type="hidden" value="55" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>Bill</td>
<td>
<a href="ideaEdit.asp?id=55" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus56" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus56" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus56" VALUE="future" />Future
</label>
<input type="hidden" value="56" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>Roberta</td>
<td>
<a href="ideaEdit.asp?id=56" class="link ideaTitle" title="New Idea">
New Idea
</a>
</td>
<td>Here's a great new idea for Towne Mortgage.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus57" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus57" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus57" VALUE="future" />Future
</label>
<input type="hidden" value="57" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>Mike</td>
<td>
<a href="ideaEdit.asp?id=57" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus58" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus58" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus58" VALUE="future" />Future
</label>
<input type="hidden" value="58" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>Rick</td>
<td>
<a href="ideaEdit.asp?id=58" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus59" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus59" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus59" VALUE="future" />Future
</label>
<input type="hidden" value="59" name="id" />
</div>
</td>
<td>8/25/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>Shelly</td>
<td>
<a href="ideaEdit.asp?id=59" class="link ideaTitle" title="Just another test">
Just another test
</a>
</td>
<td>This time let's make sure we go beyond the 50 character...</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus60" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus60" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus60" VALUE="future" />Future
</label>
<input type="hidden" value="60" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>Maryann</td>
<td>
<a href="ideaEdit.asp?id=60" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus61" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus61" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus61" VALUE="future" />Future
</label>
<input type="hidden" value="61" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>Tom</td>
<td>
<a href="ideaEdit.asp?id=61" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus62" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus62" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus62" VALUE="future" />Future
</label>
<input type="hidden" value="62" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>Amanda</td>
<td>
<a href="ideaEdit.asp?id=62" class="link ideaTitle" title="New Idea">
New Idea
</a>
</td>
<td>Here's a great new idea for Towne Mortgage.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus63" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus63" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus63" VALUE="future" />Future
</label>
<input type="hidden" value="63" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>Christina </td>
<td>
<a href="ideaEdit.asp?id=63" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus64" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus64" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus64" VALUE="future" />Future
</label>
<input type="hidden" value="64" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>John</td>
<td>
<a href="ideaEdit.asp?id=64" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus65" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus65" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus65" VALUE="future" />Future
</label>
<input type="hidden" value="65" name="id" />
</div>
</td>
<td>8/25/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>Carol</td>
<td>
<a href="ideaEdit.asp?id=65" class="link ideaTitle" title="Just another test">
Just another test
</a>
</td>
<td>This time let's make sure we go beyond the 50 character...</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus66" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus66" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus66" VALUE="future" />Future
</label>
<input type="hidden" value="66" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>Kathy</td>
<td>
<a href="ideaEdit.asp?id=66" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus67" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus67" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus67" VALUE="future" />Future
</label>
<input type="hidden" value="67" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>Olivia</td>
<td>
<a href="ideaEdit.asp?id=67" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus68" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus68" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus68" VALUE="future" />Future
</label>
<input type="hidden" value="68" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>Jack</td>
<td>
<a href="ideaEdit.asp?id=68" class="link ideaTitle" title="New Idea">
New Idea
</a>
</td>
<td>Here's a great new idea for Towne Mortgage.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus69" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus69" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus69" VALUE="future" />Future
</label>
<input type="hidden" value="69" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>Brent</td>
<td>
<a href="ideaEdit.asp?id=69" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus70" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus70" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus70" VALUE="future" />Future
</label>
<input type="hidden" value="70" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>Chris</td>
<td>
<a href="ideaEdit.asp?id=70" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus71" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus71" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus71" VALUE="future" />Future
</label>
<input type="hidden" value="71" name="id" />
</div>
</td>
<td>8/25/2011 </td>
<td>
<img src="images/smNew.png" class="help" title="New Idea!" />
<span class="status">1start</span>
</td>
<td>Lenny again</td>
<td>
<a href="ideaEdit.asp?id=71" class="link ideaTitle" title="Just another test">
Just another test
</a>
</td>
<td>This time let's make sure we go beyond the 50 character...</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus72" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus72" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus72" VALUE="future" />Future
</label>
<input type="hidden" value="72" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbUp.png" class="help" title="Continue this idea" />
<span class="status">1Continue</span>
</td>
<td>Lenny</td>
<td>
<a href="ideaEdit.asp?id=72" class="link ideaTitle" title="I really like this">
I really like this
</a>
</td>
<td>We should definitely keep this going.</td>
</tr>
<tr>
<td>
<div id="checks">
<label class="help" title="Good to go">
<INPUT TYPE="radio" NAME="updStatus73" VALUE="pass" />Pass
</label>
<label class="help" title="This one is out of here">
<INPUT TYPE="radio" NAME="updStatus73" VALUE="closed" />Closed
</label>
<label class="help" title="Maybe later">
<INPUT TYPE="radio" NAME="updStatus73" VALUE="future" />Future
</label>
<input type="hidden" value="73" name="id" />
</div>
</td>
<td>8/24/2011 </td>
<td>
<img src="images/smThumbDown.png" class="help" title="Kill this idea"/>
<span class="status">1stop</span>
</td>
<td>Lenny</td>
<td>
<a href="ideaEdit.asp?id=73" class="link ideaTitle" title="I really don't like this">
I really don't like this
</a>
</td>
<td>It should be stopped before it gets out of control!</td>
</tr>
</tbody>
</table>
<div id="buttons">
<input name="Submit" type="submit" class="submit button stop" value="Update" id="submit">
<input name="Reset" type="reset" class="reset button" value="Cancel" id="reset">
</div>
</form>
</div><!--end container -->
</div><!--end wrapper -->
<div id="sticky-footer-push"> </div>
</div><!--end wrapper -->
<div id="footer">
© 2011 Towne Mortgage
</div><!--end footer-->
<script type="text/javascript" src="includes/jquery-1.6.2.min.js"> </script>
<script type="text/javascript" src="includes/jquery-ui-1.8.15.custom.min.js"></script>
<script type="text/javascript" src="includes/jquery.dialogextend.min.js"></script>
<script type="text/javascript" src="includes/inputReplace.js"></script>
<script type="text/javascript" src="includes/jquery.tipTip.minified.js"> </script>
<script type="text/javascript" src="includes/dataTables.js"> </script>
<script type="text/javascript" src="includes/ColReorder.js"> </script>
<script type="text/javascript">
$(document).ready(function() {
positionFooter();
$(window)
.scroll(positionFooter)
.resize(positionFooter);
function positionFooter() {
var docHeight = $(document.body).height() - $("#sticky-footer-push").height();
if(docHeight < $(window).height()){
var diff = $(window).height() - docHeight;
if (!$("#sticky-footer-push").length > 0) {
$("#footer").before('<div id="sticky-footer-push"></div>');
}
$("#sticky-footer-push").height(diff);
}
}
});
</script>
<script type="text/javascript">
jQuery(function( $ ){
var container = $( "#legend" );
$( "#legendHandle" ).click(
function( event ){
event.preventDefault();
if (container.is( ":visible" )){
container.hide("slide", {direction:"up" }, 1000);
} else {
container.show("slide", {direction:"up" }, 1000);
}
}
);
});
</script>
<script type="text/javascript">
$(document).ready(function() {
$(function(){
$(".help").tipTip({delay:100});
});
});
</script>
<script type="text/javascript">
$(document).ready(function () {
$('.link').live('click', function (e) {
e.preventDefault();
var page = $(this).attr("href")
var pagetitle = $(this).attr("title")
var $dialog = $('<div></div>')
.html('<iframe style="border: 0px;overflow:hidden; " src="' + this + '" width="100%" height="100%" frameBorder="0"></iframe>')
.dialog({
autoOpen: false,
modal: false,
height: 560,
width: 540,
maximize:true,
minimize:true,
position: ['center','top'],
title: pagetitle
//show: "bounce"
})
.dialogExtend({
"maximize" : true,
"dblclick" : "maximize",
"icons" : {
"maximize" : "ui-icon-extlink",
"restore" : "ui-icon-newwin"
}
});
$dialog.dialog('open');
});
});
</script>
<script type="text/javascript">
$(document).ready(function(){
$(".stripeMe tr").mouseover(function(){$(this).addClass("over");}).mouseout(function(){$(this).removeClass("over");});
$(".stripeMe tr:even").addClass("alt");
});
</script>
<!--Row highlighting and clicking -->
<script type="text/javascript">
$(document).ready(function() {
$('#admin tr')
.filter(':has(:checkbox:checked)')
.addClass('highlight')
.end()
.click(function(event) {
$(this).toggleClass('highlight');
});
});
</script>
<!--DataTable Functions -->
<script type="text/javascript">
$(document).ready(function() {
$('#admin').dataTable( {
"aaSorting": [[ 4, "desc" ]],
"sDom": 'Rlfrtip',
"bStateSave":true,
"sPaginationType": "full_numbers"
});
});
</script>
<script type="text/javascript">
$("button").click(function () {
$(".ui-dialog-titlebar-close").remove($dialog);
});
</script>
<script type="text/javascript">
$(".submit").click(function() {
var dataString = $('form#adminUpd').serialize();
//alert (dataString);return false;
$.ajax({
type: "POST",
url: "/ideaCenter/ideaUpdate.asp",
data: dataString,
success: function() {
$('#ideaDisplay').html("<div id='message'></div>");
$('#message').html("<img id='checkmark' src='/images/check.png' /><h3>Status Updated! </h3>")
.hide()
.fadeIn(500, function() {
$('#message').append("");
});
}
});
return false;
});
</script>
</body>
</html>And here is the ideaUpdate.asp that I'm calling in the Jquery/AJAX function:
<%
If IsDate(Request("modifiedDate")) and Request("modifiedDate")<>"" then
strDate = CDate(Request("modifiedDate"))
Else
strDate = Null
End if
Conn = "Provider=SQLOLEDB; Server=TMCFILE; Uid=myusername; Pwd=mypassword; Database=myDB;"
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = Conn
MM_editCmd.CommandText = "UPDATE dbo.tblideaCenter SET updStatus = ?, modifiedDate = ? WHERE id = ?"
MM_editCmd.Prepared = True
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 201, 1, 50, Request.Form("updStatus")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 135, 1, 25, MM_IIF(Request.Form("modifiedDate"), Request.Form("modifiedDate"), null))
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 5, 1, -1, MM_IIF(Request.Form("MM_recordId"), Request.Form("MM_recordId"), null))
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
%>
Let's say I click on the Pass radio button, on the very first row, what do expect to happen?
ASKER
@sammySeltzer:When you click on a radio button, that value will be selected. The user can then click on any other radio buttons as they need. Once they have the ones they want selected, then they will hit submit. Once they hit the submit button, I'd like to update those values in the DB.
If I was me, I would first create a regular form page that submits the items to a POST page that displays all the data so I could see that I was getting what I needed. Once that worked, I would go back to AJAX and putting it in the database.
ASKER
@DaveBaldwin: My main problem is I don't even know how I would begin to write the SQL for that. I do want to get it working via POST first, but I just wanted to give my ultimate goal of AJAXing it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Correction: I said:
The way I would appreciate it would be.
I meant to say, The way I would approcah it would be.
The way I would appreciate it would be.
I meant to say, The way I would approcah it would be.