•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 402,053 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,466 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 311 | Replies: 0
 |
•
•
Join Date: Jul 2008
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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:
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>
|
•
•
•
•
•
•
•
•
DaniWeb ASP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
access advice broadband business classification code combo crime cult of the dead cow daniweb data data protection data transfer database drive dropdownlist encryption europe forensic forensics gadget google government hacking hard hardware help hitachi hp industrial espionage information internet linux mobile module net news payment services privacy protection reuse search security spot storage terabyte tutorials and more tv web wikipedia
- Previous Thread: Query Check boxes
- Next Thread: Operation is not allowed when the object is closed.
