I have a logincheck page (logincheck.asp). This code is at the top of the script:
set rscheck = con.execute("select * from authusers_reg where agencyid = '"& agencyid &"'")
if rscheck.eof then
how can i check first if the variable 'agencyid' is a valid agencyid in the table authusers?