If Statement

Good Day Everyone!



I am needing some assistance on some simple code. At least I think it simple. The purpose of the code to validate a routing number. If the submitted number is in the table, then the user is redirected to one page. If the number is not, then the user is redirected to another. Below is the code. Maybe I am needing a "True" statement. I am not quite sure. I am a novice at this.



Thanks for any assistance this is given.



(I do have a .inc file prior to this coding pointing to the database. My problem lies in the below coding and not the .inc file.)



I did have the code listed but it was not showing up??? I have removed the <% %> symbols for it show up.





Route = Replace(Trim(Request.Form("route")), "'", "''")







If route = "" Then Response.Redirect "http://128.100.1.240/forms/regcc/localtest.htm"



SQL = "Select rtnumber From local"





response.write sql

Set RS = MyConn.Execute(SQL)





If route = RS("rtnumber")Then





Response.Redirect "http://128.100.1.240/forms/regcc/localtest.htm"



Else

Response.Redirect "http://128.100.1.240/forms/regcc/nonlocaltest.htm"

End If

Hallo mikec.

The code?