Solved

Update multiple records from table in classic ASP

Posted on 2011-09-14
15
1,222 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:LZ1
  • 6
  • 4
  • 3
  • +1
15 Comments
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
I don't see the HTML output...
0
 
LVL 30

Author Comment

by:LZ1
Comment Utility
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">
		&copy; 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>

Open in new window

0
 
LVL 3

Expert Comment

by:godeschalk
Comment Utility
0
 
LVL 30

Author Comment

by:LZ1
Comment Utility
@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.
0
 
LVL 3

Expert Comment

by:godeschalk
Comment Utility
but the update is being done asp/vb

like

conn.execute("UPDATE table_name SET column1=value, column2=value2,... WHERE some_column=some_value")
0
 
LVL 3

Expert Comment

by:godeschalk
Comment Utility
here is a nice website about it http://www.w3schools.com/sql/sql_update.asp
0
 
LVL 30

Author Comment

by:LZ1
Comment Utility
What about when I have multiple rows and I'm updating one column?  How would that SQL look?
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 28

Expert Comment

by:sammySeltzer
Comment Utility
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(this.form.multipleDeletes)'>check all/uncheck all

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 = Nothing

Open in new window


Makes sense?

You just need to fix your html to show how your ajax and update and delete markups work.




       






0
 
LVL 30

Author Comment

by:LZ1
Comment Utility
@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:
<!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">
		&copy; 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>

Open in new window


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
%>

Open in new window

0
 
LVL 28

Expert Comment

by:sammySeltzer
Comment Utility
Let's say I click on the Pass radio button, on the very first row, what do expect to happen?
0
 
LVL 30

Author Comment

by:LZ1
Comment Utility
@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.  
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
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.
0
 
LVL 30

Author Comment

by:LZ1
Comment Utility
@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.
0
 
LVL 28

Accepted Solution

by:
sammySeltzer earned 500 total points
Comment Utility
Sorry, I could not get back to you sooner because I had an emergency.

I still do but have a second now.

The way I would appreciate it would be.

Count how may of those updStatus form field names you have.

So, for the sake of argument, let's say there are 25 of them, we will do something like this:

For unum = 1 To 25
Updte = Request(Trim("updStatus " & unum))
AnotherformName = Request(Trim("anotherFormName"))

    If Updte <> "" Then
        Updte = Replace(Updte , "'", "''") 'to prevent sql injection
SQL = "Update your table, set fieldname = '"&formvar&"' " _
            do the rest

   where Status IN ('" & Updte & "')"
Next ' next updStatus 

set rs= conn.execute(SQL)

Open in new window

something along these lines.

Try and if you run into bugs, post back here.

0
 
LVL 28

Expert Comment

by:sammySeltzer
Comment Utility
Correction: I said:
The way I would appreciate it would be.

I meant to say, The way I would approcah it would be.



0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now