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)")