Need help for sending data in address bar and retrieving it with query string

Reply

Join Date: Jul 2008
Posts: 1
Reputation: sindhu_dixit is an unknown quantity at this point 
Solved Threads: 0
sindhu_dixit sindhu_dixit is offline Offline
Newbie Poster

Need help for sending data in address bar and retrieving it with query string

 
0
  #1
Jul 23rd, 2008
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:

  1. <%
  2. Dim req_no
  3. req_no = Request.QueryString("req_no")
  4. %>
  5. <%
  6. DIM objConn, sqlstr, objRS
  7. Set objConn = Server.CreateObject("ADODB.Connection")
  8. sConnString = "DRIVER=SQL Server;SERVER=[];UID=[]; PWD=[];APP=;DATABASE=[]"
  9. objConn.Open sConnString
  10. mySQL = "SELECT * FROM rmarequest where req_no= "& req_no & ";"
  11. Set objRS = Server.CreateObject("ADODB.Recordset")
  12. objRS.Open mySQL, objConn
  13. %>
  14. <HTML>
  15. <HEAD>
  16. <title>A3Net Servers Inc.-RMA Details for Request Number</title>
  17. <meta name="description" content="Free web site design templates to jump start your new web site.">
  18. <meta name="keywords"
  19. content="free web site design template search graphic sets build web site">
  20.  
  21. <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
  22. <style type=text/css>
  23. BODY {
  24. 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
  25. }
  26. .bold { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9pt; font-style: normal; color: #669999; font-weight: bold}
  27. .bodyplain { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9pt; font-style: normal; color: #000000; font-weight: normal}
  28. .boldwhite { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 8pt; font-style: normal; color: #FFFFFF; font-weight: bold ; text-decoration: none}
  29. .boldwhiteCopy { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 8pt; font-style: normal; color: 4A627A; font-weight: bold ; text-decoration: none}
  30. .credit { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 8pt; font-style: normal; color: #CCCCCC; font-weight: bold ; text-decoration: none }
  31. .bodyplainred { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9pt; font-style: normal; color: #FF6633; font-weight: normal ; text-decoration: none}
  32. .bodyplaingrey { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9pt; font-style: normal; color: #999999; font-weight: normal }
  33. .bodyplainwhite { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 9pt; font-style: normal; color: 98A2AB; font-weight: normal }
  34. </style>
  35. <style type="text/css">
  36. a:link {text-decoration: none}
  37. a:active {text-decoration: none}
  38. a:visited {text-decoration: none}
  39. a:hover {text-decoration: none}
  40. </style>
  41. <style fprolloverstyle>
  42. A:hover {color: #F6D271; font-weight: bold}
  43. .style6 {
  44. font-size: 10pt;
  45. font-weight: bold;
  46. }
  47. .style7 {font-family: "MS Sans Serif"}
  48. .style8 {font-size: 10pt; font-weight: bold; font-family: "MS Sans Serif"; }
  49. .style10 {
  50. font-family: "MS Sans Serif";
  51. font-size: 1pt;
  52. color: #000066;
  53. font-weight: bold;
  54. }
  55. .style13 {font-size: 10pt}
  56. .style14 {font-size: 1pt; color: #000066; font-family: "MS Sans Serif";}
  57. .style16 {
  58. font-family: "MS Sans Serif";
  59. color: #003333;
  60. font-weight: bold;
  61. font-size: medium;
  62. }
  63. .style24 {
  64. font-family: Verdana, Arial, Helvetica, sans-serif;
  65. color: #FF0000;
  66. font-size: 9pt;
  67. }
  68. .style25 {
  69. font-size: x-small;
  70. font-weight: bold;
  71. color: #000066;
  72. }
  73. .style27 {color: #336699}
  74. </style>
  75.  
  76. </HEAD>
  77.  
  78.  
  79.  
  80. <BODY BGCOLOR=#FFFFFF leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
  81.  
  82. <span class="bodyplaingrey"></span> <span class="bodyplainred"></span> <span class="credit"></span>
  83. <span class="boldwhiteCopy"></span> <span class="boldwhite"></span> <span class="bodyplain"></span>
  84.  
  85.  
  86. <div align="left">
  87.  
  88.  
  89. <table width="750" cellspacing="0" cellpadding="0">
  90. <tr>
  91. <td class="bodyplain"><table width="100%" border="0" cellspacing="0" cellpadding="0">
  92. <tr>
  93. <td colspan="2" height="111"><img border="0" src="/a3netSiteBanner.jpg" height="100%" width="100%"> </td>
  94. </tr>
  95. <tr>
  96. <td bgcolor="#5F6F7F" height="18"><div align="left"> </div></td>
  97. <td height="18"><div align="left"> </div></td>
  98. </tr>
  99. <tr>
  100. <td width="141" bgcolor="#5F6F7F" valign="top"><div align="center"> </div></td>
  101. <td align="left" valign="top"><form name="form1" method="post" action="">
  102. <table width="95%" border="0" cellpadding="0" cellspacing="0">
  103. <tr>
  104. <td width="100%" height="20"><div align="center">
  105. <center>
  106. <table border="0" cellpadding="0" cellspacing="0" width="100%" height="255">
  107. <tr>
  108. <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>
  109. </tr>
  110. <tr>
  111. <td width="50%" height="205" align="left" valign="bottom"><div align="left" class="style7">
  112. <table width="574" border="0" align="left" cellpadding="0" cellspacing="0" bordercolor="#e2e2e2">
  113. <tr>
  114. <td width="279" align="left" valign="top" class="style7">&nbsp;</td>
  115. <td width="288" align="left" valign="top" class="style6">&nbsp;</td>
  116. </tr>
  117. <tr bgcolor="#dfdfdf">
  118. <td height="20" align="left" valign="middle" class="style25">&nbsp;Request Number:
  119. <% Response.Write req_no %>
  120. </td>
  121. <td height="20" align="left" valign="top" bgcolor="#dfdfdf" class="style6">&nbsp;</td>
  122. </tr>
  123. <tr>
  124. <td align="left" valign="top" class="style7">&nbsp;</td>
  125. <td align="left" valign="top" class="style6">&nbsp;</td>
  126. </tr>
  127. <tr align="left" valign="top">
  128. <td colspan="2" class="style8"><table width="574" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
  129. <tr bgcolor="#E0E8B7">
  130. <td width="83" align="center" valign="middle" bgcolor="#E0E8B7" class="style10">Model/Part#</td>
  131. <td width="45" align="center" valign="middle" bgcolor="#E0E8B7" class="style10">Qty</td>
  132. <td width="76" align="center" valign="middle" bgcolor="#E0E8B7" class="style10">Invoice#</td>
  133. <td width="75" align="center" valign="middle" bgcolor="#E0E8B7" class="style10"> P.O#</td>
  134. <td width="90" align="center" valign="middle" bgcolor="#E0E8B7" class="style10">Invoice<br>
  135. Date </td>
  136. <td width="39" align="center" valign="middle" bgcolor="#E0E8B7" class="style10">Serial#</td>
  137. <td width="156" align="center" valign="middle" bgcolor="#E0E8B7" class="style10">Problem</td>
  138. </tr>
  139. </table></td>
  140. </tr>
  141. <tr align="left" valign="top">
  142. <td colspan="2" class="style8"><table width="574" border="0" align="center" cellpadding="2" cellspacing="2">
  143. <tr align="center" valign="middle">
  144. <td width="78"><input name="part1" type="text" id="part1 "class="style14" size="11" value="<%=objRS("part1")%>"></td>
  145. <td width="28"><input name="qty1" type="text" id="qty1" class="style14" size="3" value="<%=objRS("qty1")%>"></td>
  146. <td width="65"><input name="invoice1" type="text" id="invoice1" class="style14" size="13" value="<%=objRS("inv1")%>"></td>
  147. <td width="65"><input name="po1" type="text" id="po1" class="style14" size="12" value="<%=objRS("po1")%>"></td>
  148. <td width="60"><input name="date1" type="text" id="date1" class="style14" size="10" value="<%=objRS("inv_date1")%>"></td>
  149. <td width="60"><input name="serial1" type="text" id="serial1" class="style14" size="10" value="<%=objRS("serial1")%>"></td>
  150. <td width="171"><select name="problem1" id="problem1" size="1" class="style14" select value="<%=objRS("problem1")%>">
  151. <option value="#">-Choose One-</option>
  152. <option value="DOA">DOA</option>
  153. <option value="Wrong Product Shipped">Wrong Product Shipped</option>
  154. <option value="Failed-Under Warranty">Failed-Under Warranty</option>
  155. <option value="Evaluation(Pre-Apprv)">Evaluation (Pre-Apprv) </option>
  156. <option value="Other">Other(Explain)</option>
  157. </select></td>
  158. </tr>
  159. <tr align="center" valign="middle">
  160. <td width="78"><input name="part2" type="text" id="part2 "class="style14" size="11" value="<%=objRS("part2")%>"></td>
  161. <td width="28"><input name="qty2" type="text" class="style14" id="qty2" size="3" value="<%=objRS("qty2")%>"></td>
  162. <td><input name="invoice2" type="text" class="style14" id="invoice2" size="13" value="<%=objRS("inv2")%>"></td>
  163. <td><input name="po2" type="text" class="style14" id="po2" size="12" value="<%=objRS("po2")%>"></td>
  164. <td><input name="date2" type="text" class="style14" id="date2" size="10" value="<%=objRS("inv_date2")%>"></td>
  165. <td><input name="serial2" type="text" class="style14" id="serial2" size="10" value="<%=objRS("serial2")%>"></td>
  166. <td><select name="problem2" size="1" class="style14" id="problem2" value="<%=objRS("problem2")%>">
  167. <option value="#">-Choose One-</option>
  168. <option value="DOA">DOA</option>
  169. <option value="Wrong Product Shipped">Wrong Product Shipped</option>
  170. <option value="Failed-Under Warranty">Failed-Under Warranty</option>
  171. <option value="Evaluation(Pre-Apprv)">Evaluation (Pre-Apprv) </option>
  172. <option value="Other">Other(Explain)</option>
  173. </select></td>
  174. </tr>
  175. <tr align="center" valign="middle">
  176. <td width="78"><input name="part3" type="text" id="part3 "class="style14" size="11" value="<%=objRS("part3")%>"></td>
  177. <td width="28"><input name="qty3" type="text" class="style14" id="qty3" size="3" value="<%=objRS("qty3")%>"></td>
  178. <td><input name="invoice3" type="text" class="style14" id="invoice3" size="13" value="<%=objRS("inv3")%>"></td>
  179. <td><input name="po3" type="text" class="style14" id="po3" size="12" value="<%=objRS("po3")%>"></td>
  180. <td><input name="date3" type="text" class="style14" id="date3" size="10" value="<%=objRS("inv_date3")%>"></td>
  181. <td><input name="serial3" type="text" class="style14" id="serial3" size="10" value="<%=objRS("serial3")%>"></td>
  182. <td><select name="problem3" size="1" class="style14" id="problem3" value="<%=objRS("problem3")%>">
  183. <option value="#">-Choose One-</option>
  184. <option value="DOA">DOA</option>
  185. <option value="Wrong Product Shipped">Wrong Product Shipped</option>
  186. <option value="Failed-Under Warranty">Failed-Under Warranty</option>
  187. <option value="Evaluation(Pre-Apprv)">Evaluation (Pre-Apprv) </option>
  188. <option value="Other">Other(Explain)</option>
  189. </select></td>
  190. </tr>
  191. <tr align="center" valign="middle">
  192. <td width="78"><input name="part4" type="text" id="part4 "class="style14" size="11" value="<%=objRS("part4")%>"></td>
  193. <td width="28"><input name="qty4" type="text" class="style14" id="qty4" size="3" value="<%=objRS("qty4")%>"></td>
  194. <td><input name="invoice4" type="text" class="style14" id="invoice4" size="13" value="<%=objRS("inv4")%>"></td>
  195. <td><input name="po4" type="text" class="style14" id="po4" size="12" value="<%=objRS("po4")%>"></td>
  196. <td><input name="date4" type="text" class="style14" id="date4" size="10" value="<%=objRS("inv_date4")%>"></td>
  197. <td><input name="serial4" type="text" class="style14" id="serial4" size="10" value="<%=objRS("serial4")%>"></td>
  198. <td><select name="problem4" size="1" class="style14" id="problem4" value="<%=objRS("problem4")%>">
  199. <option value="#">-Choose One-</option>
  200. <option value="DOA">DOA</option>
  201. <option value="Wrong Product Shipped">Wrong Product Shipped</option>
  202. <option value="Failed-Under Warranty">Failed-Under Warranty</option>
  203. <option value="Evaluation(Pre-Apprv)">Evaluation (Pre-Apprv) </option>
  204. <option value="Other">Other(Explain)</option>
  205. </select></td>
  206. </tr>
  207. </table></td>
  208. </tr>
  209. <tr align="left" valign="top">
  210. <td colspan="2" class="style8">&nbsp;</td>
  211. </tr>
  212. <tr align="left" valign="middle">
  213. <td height="20" colspan="2" class="style10"><span class="style24">*</span>Term of Exchange:<br>
  214. &nbsp;&nbsp;
  215. <select name="terms" size="1" class="style14" id="terms" value="<%=objRS("terms")%>">
  216. <option value="Replacement">Replacement</option>
  217. <option value="Credit">Credit</option>
  218. <option value="Repair">Repair</option>
  219. </select></td>
  220. </tr>
  221. <tr align="left" valign="top">
  222. <td colspan="2" class="style8">&nbsp;</td>
  223. </tr>
  224. <tr align="left" valign="top">
  225. <td colspan="2" class="style10"><span class="style24">*</span>Delivery Method: <br>
  226. &nbsp;&nbsp;
  227. <select name="delivery" size="1" class="style14" id="delivery" value="<%=objRS("delivery")%>">
  228. <option value="Fedex Saver">Fedex Saver</option>
  229. <option value="Overnight">Overnight</option>
  230. <option value="Ground" selected>Ground</option>
  231. </select>
  232. </td>
  233. </tr>
  234. <tr align="left" valign="top">
  235. <td colspan="2" class="style8">&nbsp;</td>
  236. </tr>
  237. <tr align="left" valign="top">
  238. <td colspan="2" class="style10">&nbsp;&nbsp;Problem Details: <br>
  239. &nbsp;&nbsp;
  240. <textarea name="Comments" cols="100" rows="5" wrap="VIRTUAL" class="style14" id="Comments"><%=objRS("comments")%></textarea></td>
  241.  
  242.  
  243. </tr>
  244. <tr align="left" valign="top">
  245. <td colspan="2" class="style8"><%
  246. objRS.Close
  247. Set objRS = Nothing
  248. objConn.Close
  249. Set objConn = Nothing
  250. %></td>
  251. </tr>
  252. <tr align="left" valign="top">
  253. <td colspan="2" class="style8">&nbsp;&nbsp;
  254.  
  255. <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>
  256. </tr>
  257. </table>
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the ASP Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC