I have a form which displays data retrieved from database in suppose first 10 feilds.There is an update button at the end
of the 10th feild.
My user can change the data in the feilds and update them.When user clicks the update button i want all the info to go to another asp page which is the same replica of the first page except its performing the update in the text feilds.
I cannot do that by post form method cause I have 6 buttons in the same form performing different database queries.
My questions are:
1. How can I send all the values of the text feilds to the next page in address bar so I can retrieve them on the next page using Response.Querystring method.
Please suggest how can I transfer other feild values like part1,qty1 etc with req_no in the below code line.Other feild values may be updated ot stay same as retrieved from DB.
<input name="submitvalues" type="button" value="Update Request" ; onClick="location.href='RMAdetails1.asp? req_no=<%=objRS("req_no")%>'">
This is part of the code:
<%
Dim req_no
req_no = Request.QueryString("req_no")
%>
<%
DIM objConn, sqlstr, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
sConnString = "DRIVER=SQL Server;SERVER=[];UID=[]; PWD=[];APP=;DATABASE=[]"
objConn.Open sConnString
mySQL = "SELECT * FROM rmarequest where req_no= "& req_no & ";"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open mySQL, objConn
%>
<HTML>
<HEAD>
<title>A3Net Servers Inc.-RMA Details for Request Number</title>
<meta name="description" content="Free web site design templates to jump start your new web site.">
<meta name="keywords"
content="free web site design template search graphic sets build web site">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<style type=text/css>
BODY {
SCROLLBAR-ARROW-COLOR: #97AABA; SCROLLBAR-FACE-COLOR: #F2F5F7; SCROLLBAR-HIGHLIGHT-COLOR: #B2C3D0; SCROLLBAR-SHADOW-COLOR: #B2C3D0; SCROLLBAR-3DLIGHT-COLOR: #ffffff; SCROLLBAR-TRACK-COLOR: #FFFFFF; SCROLLBAR-DARKSHADOW-COLOR: #FFFFFF
}
.bold { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9pt; font-style: normal; color: #669999; font-weight: bold}
.bodyplain { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9pt; font-style: normal; color: #000000; font-weight: normal}
.boldwhite { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 8pt; font-style: normal; color: #FFFFFF; font-weight: bold ; text-decoration: none}
.boldwhiteCopy { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 8pt; font-style: normal; color: 4A627A; font-weight: bold ; text-decoration: none}
.credit { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 8pt; font-style: normal; color: #CCCCCC; font-weight: bold ; text-decoration: none }
.bodyplainred { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9pt; font-style: normal; color: #FF6633; font-weight: normal ; text-decoration: none}
.bodyplaingrey { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9pt; font-style: normal; color: #999999; font-weight: normal }
.bodyplainwhite { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9pt; font-style: normal; color: 98A2AB; font-weight: normal }
</style>
<style type="text/css">
a:link {text-decoration: none}
a:active {text-decoration: none}
a:visited {text-decoration: none}
a:hover {text-decoration: none}
</style>
<style fprolloverstyle>
A:hover {color: #F6D271; font-weight: bold}
.style6 {
font-size: 10pt;
font-weight: bold;
}
.style7 {font-family: "MS Sans Serif"}
.style8 {font-size: 10pt; font-weight: bold; font-family: "MS Sans Serif"; }
.style10 {
font-family: "MS Sans Serif";
font-size: 1pt;
color: #000066;
font-weight: bold;
}
.style13 {font-size: 10pt}
.style14 {font-size: 1pt; color: #000066; font-family: "MS Sans Serif";}
.style16 {
font-family: "MS Sans Serif";
color: #003333;
font-weight: bold;
font-size: medium;
}
.style24 {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #FF0000;
font-size: 9pt;
}
.style25 {
font-size: x-small;
font-weight: bold;
color: #000066;
}
.style27 {color: #336699}
</style>
</HEAD>
<BODY BGCOLOR=#FFFFFF leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
<span class="bodyplaingrey"></span> <span class="bodyplainred"></span> <span class="credit"></span>
<span class="boldwhiteCopy"></span> <span class="boldwhite"></span> <span class="bodyplain"></span>
<div align="left">
<table width="750" cellspacing="0" cellpadding="0">
<tr>
<td class="bodyplain"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" height="111"><img border="0" src="/a3netSiteBanner.jpg" height="100%" width="100%"> </td>
</tr>
<tr>
<td bgcolor="#5F6F7F" height="18"><div align="left"> </div></td>
<td height="18"><div align="left"> </div></td>
</tr>
<tr>
<td width="141" bgcolor="#5F6F7F" valign="top"><div align="center"> </div></td>
<td align="left" valign="top"><form name="form1" method="post" action="">
<table width="95%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" height="20"><div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="100%" height="255">
<tr>
<td width="100%" height="28" align="left" valign="middle"><span class="style16"> <b><font face="Webdings" size="3" color="#DFAE0E">8</font></b>RMA <span class="style27">Details<b><font face="Webdings" size="3" color="#DFAE0E">7</font></b></span></span></td>
</tr>
<tr>
<td width="50%" height="205" align="left" valign="bottom"><div align="left" class="style7">
<table width="574" border="0" align="left" cellpadding="0" cellspacing="0" bordercolor="#e2e2e2">
<tr>
<td width="279" align="left" valign="top" class="style7"> </td>
<td width="288" align="left" valign="top" class="style6"> </td>
</tr>
<tr bgcolor="#dfdfdf">
<td height="20" align="left" valign="middle" class="style25"> Request Number:
<% Response.Write req_no %>
</td>
<td height="20" align="left" valign="top" bgcolor="#dfdfdf" class="style6"> </td>
</tr>
<tr>
<td align="left" valign="top" class="style7"> </td>
<td align="left" valign="top" class="style6"> </td>
</tr>
<tr align="left" valign="top">
<td colspan="2" class="style8"><table width="574" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="#E0E8B7">
<td width="83" align="center" valign="middle" bgcolor="#E0E8B7" class="style10">Model/Part#</td>
<td width="45" align="center" valign="middle" bgcolor="#E0E8B7" class="style10">Qty</td>
<td width="76" align="center" valign="middle" bgcolor="#E0E8B7" class="style10">Invoice#</td>
<td width="75" align="center" valign="middle" bgcolor="#E0E8B7" class="style10"> P.O#</td>
<td width="90" align="center" valign="middle" bgcolor="#E0E8B7" class="style10">Invoice<br>
Date </td>
<td width="39" align="center" valign="middle" bgcolor="#E0E8B7" class="style10">Serial#</td>
<td width="156" align="center" valign="middle" bgcolor="#E0E8B7" class="style10">Problem</td>
</tr>
</table></td>
</tr>
<tr align="left" valign="top">
<td colspan="2" class="style8"><table width="574" border="0" align="center" cellpadding="2" cellspacing="2">
<tr align="center" valign="middle">
<td width="78"><input name="part1" type="text" id="part1 "class="style14" size="11" value="<%=objRS("part1")%>"></td>
<td width="28"><input name="qty1" type="text" id="qty1" class="style14" size="3" value="<%=objRS("qty1")%>"></td>
<td width="65"><input name="invoice1" type="text" id="invoice1" class="style14" size="13" value="<%=objRS("inv1")%>"></td>
<td width="65"><input name="po1" type="text" id="po1" class="style14" size="12" value="<%=objRS("po1")%>"></td>
<td width="60"><input name="date1" type="text" id="date1" class="style14" size="10" value="<%=objRS("inv_date1")%>"></td>
<td width="60"><input name="serial1" type="text" id="serial1" class="style14" size="10" value="<%=objRS("serial1")%>"></td>
<td width="171"><select name="problem1" id="problem1" size="1" class="style14" select value="<%=objRS("problem1")%>">
<option value="#">-Choose One-</option>
<option value="DOA">DOA</option>
<option value="Wrong Product Shipped">Wrong Product Shipped</option>
<option value="Failed-Under Warranty">Failed-Under Warranty</option>
<option value="Evaluation(Pre-Apprv)">Evaluation (Pre-Apprv) </option>
<option value="Other">Other(Explain)</option>
</select></td>
</tr>
<tr align="center" valign="middle">
<td width="78"><input name="part2" type="text" id="part2 "class="style14" size="11" value="<%=objRS("part2")%>"></td>
<td width="28"><input name="qty2" type="text" class="style14" id="qty2" size="3" value="<%=objRS("qty2")%>"></td>
<td><input name="invoice2" type="text" class="style14" id="invoice2" size="13" value="<%=objRS("inv2")%>"></td>
<td><input name="po2" type="text" class="style14" id="po2" size="12" value="<%=objRS("po2")%>"></td>
<td><input name="date2" type="text" class="style14" id="date2" size="10" value="<%=objRS("inv_date2")%>"></td>
<td><input name="serial2" type="text" class="style14" id="serial2" size="10" value="<%=objRS("serial2")%>"></td>
<td><select name="problem2" size="1" class="style14" id="problem2" value="<%=objRS("problem2")%>">
<option value="#">-Choose One-</option>
<option value="DOA">DOA</option>
<option value="Wrong Product Shipped">Wrong Product Shipped</option>
<option value="Failed-Under Warranty">Failed-Under Warranty</option>
<option value="Evaluation(Pre-Apprv)">Evaluation (Pre-Apprv) </option>
<option value="Other">Other(Explain)</option>
</select></td>
</tr>
<tr align="center" valign="middle">
<td width="78"><input name="part3" type="text" id="part3 "class="style14" size="11" value="<%=objRS("part3")%>"></td>
<td width="28"><input name="qty3" type="text" class="style14" id="qty3" size="3" value="<%=objRS("qty3")%>"></td>
<td><input name="invoice3" type="text" class="style14" id="invoice3" size="13" value="<%=objRS("inv3")%>"></td>
<td><input name="po3" type="text" class="style14" id="po3" size="12" value="<%=objRS("po3")%>"></td>
<td><input name="date3" type="text" class="style14" id="date3" size="10" value="<%=objRS("inv_date3")%>"></td>
<td><input name="serial3" type="text" class="style14" id="serial3" size="10" value="<%=objRS("serial3")%>"></td>
<td><select name="problem3" size="1" class="style14" id="problem3" value="<%=objRS("problem3")%>">
<option value="#">-Choose One-</option>
<option value="DOA">DOA</option>
<option value="Wrong Product Shipped">Wrong Product Shipped</option>
<option value="Failed-Under Warranty">Failed-Under Warranty</option>
<option value="Evaluation(Pre-Apprv)">Evaluation (Pre-Apprv) </option>
<option value="Other">Other(Explain)</option>
</select></td>
</tr>
<tr align="center" valign="middle">
<td width="78"><input name="part4" type="text" id="part4 "class="style14" size="11" value="<%=objRS("part4")%>"></td>
<td width="28"><input name="qty4" type="text" class="style14" id="qty4" size="3" value="<%=objRS("qty4")%>"></td>
<td><input name="invoice4" type="text" class="style14" id="invoice4" size="13" value="<%=objRS("inv4")%>"></td>
<td><input name="po4" type="text" class="style14" id="po4" size="12" value="<%=objRS("po4")%>"></td>
<td><input name="date4" type="text" class="style14" id="date4" size="10" value="<%=objRS("inv_date4")%>"></td>
<td><input name="serial4" type="text" class="style14" id="serial4" size="10" value="<%=objRS("serial4")%>"></td>
<td><select name="problem4" size="1" class="style14" id="problem4" value="<%=objRS("problem4")%>">
<option value="#">-Choose One-</option>
<option value="DOA">DOA</option>
<option value="Wrong Product Shipped">Wrong Product Shipped</option>
<option value="Failed-Under Warranty">Failed-Under Warranty</option>
<option value="Evaluation(Pre-Apprv)">Evaluation (Pre-Apprv) </option>
<option value="Other">Other(Explain)</option>
</select></td>
</tr>
</table></td>
</tr>
<tr align="left" valign="top">
<td colspan="2" class="style8"> </td>
</tr>
<tr align="left" valign="middle">
<td height="20" colspan="2" class="style10"><span class="style24">*</span>Term of Exchange:<br>
<select name="terms" size="1" class="style14" id="terms" value="<%=objRS("terms")%>">
<option value="Replacement">Replacement</option>
<option value="Credit">Credit</option>
<option value="Repair">Repair</option>
</select></td>
</tr>
<tr align="left" valign="top">
<td colspan="2" class="style8"> </td>
</tr>
<tr align="left" valign="top">
<td colspan="2" class="style10"><span class="style24">*</span>Delivery Method: <br>
<select name="delivery" size="1" class="style14" id="delivery" value="<%=objRS("delivery")%>">
<option value="Fedex Saver">Fedex Saver</option>
<option value="Overnight">Overnight</option>
<option value="Ground" selected>Ground</option>
</select>
</td>
</tr>
<tr align="left" valign="top">
<td colspan="2" class="style8"> </td>
</tr>
<tr align="left" valign="top">
<td colspan="2" class="style10"> Problem Details: <br>
<textarea name="Comments" cols="100" rows="5" wrap="VIRTUAL" class="style14" id="Comments"><%=objRS("comments")%></textarea></td>
</tr>
<tr align="left" valign="top">
<td colspan="2" class="style8"><%
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%></td>
</tr>
<tr align="left" valign="top">
<td colspan="2" class="style8">
<input name="submitvalues" type="button" class="style14" style="color: #003333; font-family: MS Sans Serif; font-size: 8pt; border: 1 solid #003333" value="Update Request" ; onClick="location.href='RMAdetails1.asp? req_no=<%=objRS("req_no")%>'"></td>
</tr>
</table>