<div>
have a look at the recordCount property - <a href="http://www.w3schools.com/ADO/prop_rs_recordcount.asp" rel="ugc">http://www.w3schools.com/ADO/prop_rs_recordcount.asp</a>
</div>


have a look at the recordCount property - http://www.w3schools.com/ADO/prop_rs_recordcount.asp [http://www.w3schools.com/ADO/prop_rs_recordcount.asp]

<div>
any hints on syntax to include the required parameter in the url ?
</div>


any hints on syntax to include the required parameter in the url ?

<div>
<div class="content wysiwyg-content">
I want to redirect a user if their recordset has only one result. &nbsp;When they are redirected, I need to pass the url variable. &nbsp;Otherwise, I will leave them on the results.asp page. &nbsp;<br />
This is the code I have so far, but it does not work:<br />
<br />
&lt;%<br />
If rsCustomerData_total = 1 Then<br />
Response.Redirect(&quot;Contact<wbr />Management<wbr />ActivityAd<wbr />d.asp? &amp;&nbsp;var_Table_ID=(rsCustomerDa<wbr />ta.Fields.<wbr />Item(&quot;Tabl<wbr />e_ID&quot;).Val<wbr />ue)&quot;)<br />
End If<br />
%&gt;
</div>
</div>


I want to redirect a user if their recordset has only one result.  When they are redirected, I need to pass the url variable.  Otherwise, I will leave them on the results.asp page.  
This is the code I have so far, but it does not work:

<%
If rsCustomerData_total = 1 Then
Response.Redirect("ContactManagementActivityAdd.asp? & var_Table_ID=(rsCustomerData.Fields.Item("Table_ID").Value)")
End If
%>

Redirect with parameter if Recordset has only one record

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.