Response.redirect?

[cwolgamott]

Hello. I am working on an ASP page that I want to be able to display some information from a SQL Server database table. I check for a record counter, and if there is more than one record, I want to redirect it to a different page. The most current code that I have tried is:

If NOT rs.eof then
rs.movefirst
Do until rs.eof
recCounter = recCounter + 1
rs.movenext
loop
End If
Response.write recCounter

If recCounter > 1 then
Response.Redirect "newcaseselectextension.asp?Extension=" & Request("extension&quot
End If

I have been searching for some examples, but none of the ones I have found work. I would greatly appreciate any help or suggestions. Thank you.

 

[cwolgamott]

I was actually able to figure it out. I displayed both the newcaseselectextension.asp and Extension.