Classic ASP - data passed from one page to another page
Perhaps someone can help me on this issue:
I am trying to pass data from one page#1 to another page#2.
1. In page#1, a Query is generated with an I.D., and Name.
sqlStmt = "SELECT QDGM.ADGM_NM AS QDGM_NM, "
sqlStmt = sqlStmt & "QDGM.QDGM_ID AS QDGM_ID, "
sqlStmt = sqlStmt & "QDGM.QDGM_NMBR AS QDGM_NMBR "
sqlStmt = sqlStmt & "FROM QDGM ORDER BY QDGM.QDGM_NMBR "
set rstemp=conntemp.execute(sqlStmt)
2. The data on Page#2 is generated which appears.
QDGM_NMBR QDGM_ID
( QGM20110041] 450 ) <--- clicked on data line
3. When I click on the the line of data, I want the I.D. number totransfer to Page#2. The connection to page#2 does occur, but, not the I.D. data transfer. Do i need to include or subject anything from href or maybe use some other code? Thanks for your help.
Here is my href.
do while not rstemp.eof %>
<a href="templates/qdgm_rltn.asp" target="_blank">[<%=trim(rstemp("QDGM_NMBR"))%>] <%=rstemp("QDGM_ID")%></a></FONT><br>
stemp.movenext
loop
4. Here is Page#2 which does connect to Page#1. It produces an error message when the I.D. is not transferred in Page#2.
Line of code in Page#2:
<%QDGM_ID=REQUEST.FORM("QDGM") %>
' used a message box with the value of and I.D. - to see if data was passed.
%>
<%if QDGM_ID <> "" then%>
<%'Set initial values
A=1
%>
else
Error........No ID was found
|