Referencing a query string on another query in asp
I want to be able to build a query string(Qry2) in my asp code which would take data from the outputs of another query string (Qry1) from the same code. Can anyone please tell me how I could reference Qry1 in Qry2?
href="pagename.asp?param1=<%=request.querystr ing("OldQSParam1")%>¶m2=<%=request.q uerystring("OldQSParam2")%>"<BR><BR>is this what you were asking<BR><BR>I really dont understand your question
I meant: Suppose I have<BR>str1 = "SELECT fld1, fld2, fld3 from Table WHERE ..."<BR>in my asp code, then I want to be able to write in the same code<BR>str2 = "SELECT [str1].fld1 ... FROM [str1] WHERE ...".<BR><BR>Is there any way I could reference str1 in str2? Would ba a great help if I got an answer.<BR>Thanks!<BR>