Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

querystring values to form

Status
Not open for further replies.
cindy0904

cindy0904

Technical User
May 30, 2002
29
US
hi, i have two pages, index.asp and moreinfo.asp. Index.asp should pass 3 querystring db field values to moreinfo.asp. It passes two but leaves the third blank. It was working and still does locally but not live. Driving me crazy. Any ideas? (3 fields are itemID, itemname, amount). then click more info button.

thanks for any suggestions.

cindy
 
Sort by date Sort by votes
sorry, maybe i didn't provide enough info (or too much!)
--cindy
****************

The moreinfo button on index.asp has this link:
<a href=&quot;moreinfo.asp?itemID=<%=(Recordset1.Fields.Item(&quot;itemID&quot;).Value)%>&itemname=<%=(Recordset1.Fields.Item(&quot;itemname&quot;).Value)%>&amount=<%=(Recordset1.Fields.Item(&quot;amount&quot;).Value)%>&quot;><img src=&quot;/images/moreinfo_c.gif&quot; width=&quot;86&quot; height=&quot;18&quot; border=&quot;0&quot;></a>

The moreinfo.asp page code:
<%@LANGUAGE=&quot;VBSCRIPT&quot;%>
<!--#include file=&quot;Connections/ss.asp&quot; -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = &quot;1&quot;
if (Request.QueryString(&quot;itemID&quot;) <> &quot;&quot;) then Recordset1__MMColParam = Request.QueryString(&quot;itemID&quot;)
%>
<%
set Recordset1 = Server.CreateObject(&quot;ADODB.Recordset&quot;)
Recordset1.ActiveConnection = MM_ss_STRING
Recordset1.Source = &quot;SELECT * FROM items WHERE itemID = &quot; + Replace(Recordset1__MMColParam, &quot;'&quot;, &quot;''&quot;) + &quot; ORDER BY itemname ASC&quot;
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<html>
<head>
<meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=windows-1252&quot;>
<meta name=&quot;GENERATOR&quot; content=&quot;Microsoft FrontPage 4.0&quot;>
<meta name=&quot;ProgId&quot; content=&quot;FrontPage.Editor.Document&quot;>
<title>SamuraiSalvage.com - More Info Request</title>
<link rel=&quot;stylesheet&quot; href=&quot;/style.css&quot; type=&quot;text/css&quot;>
</head>
<body bgcolor=&quot;#FFFF99&quot;>
<div align=&quot;center&quot;><img src=&quot;/images/logo_thanks.gif&quot; width=&quot;136&quot; height=&quot;145&quot;>
<hr width=&quot;400&quot;>
</div>
<table width=&quot;70%&quot; border=&quot;0&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; align=&quot;center&quot;>
<tr>
<td>
<form name=&quot;form1&quot; method=&quot;post&quot; action=&quot;sendmail.asp&quot;>
<div align=&quot;center&quot;>
<p><b class=&quot;spothead&quot;>REQUEST FOR MORE INFORMATION</b><br>
<b><%=(Recordset1.Fields.Item(&quot;itemname&quot;).Value)%></b> <br>
<%= FormatCurrency((Recordset1.Fields.Item(&quot;amount&quot;).Value), 0, -2, -2, -2) %>

</div>
<hr width=&quot;400&quot;>
<p align=&quot;center&quot;>Please complete this form or, <a href=&quot;javascript:history.go(-1)&quot;>go
back</a> to the previous page.<br>
<br>
<b>Your name:</b>
<input type=&quot;text&quot; size=&quot;25&quot; name=&quot;name&quot;>
<b>Your email:</b>
<input type=&quot;text&quot; size=&quot;25&quot; name=&quot;email&quot;>
</p>
<div align=&quot;center&quot;><b>Your Question:</b><br>
<textarea name=&quot;body&quot; cols=&quot;67&quot; rows=&quot;5&quot; wrap=&quot;PHYSICAL&quot;></textarea>
<input type=&quot;hidden&quot; name=&quot;amount&quot; value=&quot;<%=(Recordset1.Fields.Item(&quot;amount&quot;).Value)%>&quot;>
<input type=&quot;hidden&quot; name=&quot;itemname&quot; value=&quot;<%=(Recordset1.Fields.Item(&quot;itemname&quot;).Value)%>&quot;>
</div>
<div align=&quot;center&quot;>
<input type=&quot;submit&quot; name=&quot;Submit&quot; value=&quot;Submit&quot;>
<br>
</div>
</form>
</td>
</tr>
</table>
</body>
</html>
<%
Recordset1.Close()
%>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How to send HTML emails with ASP classic?
Replies
0
Views
431
leifoet
leifoet
penguinspeaks
  • Locked
  • Question
Return to current location on page after asp processes.
Replies
2
Views
364
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
How to check if a datatable is empty ?
Replies
0
Views
338
leifoet
leifoet
bslintx2021
  • Locked
  • Question
How to configure IIS 10 server to allow Classic ASP to connect to MSSQL server database on a domain
Replies
1
Views
747
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
How to link a condition to a session(&quot;UID&quot;) ?
Replies
14
Views
460
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top