Pass a parameter in a link
Can someone please help me with the syntax on how I can pass a parameter from a variable to a web page? I am passing blank with my code below.
Here's what I am trying to do. I need to pass the content of a field called rsMemControl("MemberID" to parm_id to a website. Everytime I would click the link it will go the the website but parm_id will be blank. Below is my code. Please help me.
strSQL = "SELECT * FROM Member_Control " & _
"WHERE SSN = " & Session("SSN") & ";"
Set rsMemControl = Server.CreateObject("ADODB.Recordset")
rsMemControl.Open strSQL, objConn
<h1 style="text-align: justify">Disclaimer</h1>
<p class="MsoNormal" style="text-align: justify">Any questions about any potential changes in the current system of benefits in this survey do not constitute any kind of âvoteâ on benefits. In fact, until the Houston Firefighters' Relief and Retirement Fund is more than 100% funded, the Board is not in a position to pursue benefits that have an actuarial cost. Therefore, any questions in this survey about improvements to benefits will relate to possible activity in a future Texas Legislature, but not the Legislature that is upcoming in January of 2007.</p>
<p class="MsoNormal" style="text-align: center; text-indent: -.25in; margin-left: .75in">
<a href="http://www.ridgecrestsurveys.com/sur.php?usn=oq2346l&pwd=fa41a5ba72a7&parm_id="& rsMemControl("MemberID")>I Agree</a>
<a target="_top" href="Browselistings.asp">I Do Not Agree</a></p>