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
     response.redirect "/mackenzie/asp/reg.asp"
end if

%>

how can i check first if the variable 'agencyid' is a valid agencyid in the table authusers?

Picco

www.crmpicco.co.uk

__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk

I didn't understand your problem. The code given by you is correct if agencyid field of authusers_reg table is of char/varchar datatype.

If agencyid field is of integer / long datatype, you have to use this code.

<%
if(agencyid<>"" and not(isnull(agencyid))) then
    if(isnumeric(trim(agencyid))) then
        set rscheck = con.execute("select * from authusers_reg where agencyid = "& trim(agencyid))

        if rscheck.eof then
             response.redirect "/mackenzie/asp/reg.asp"
        end if
    end if
end if
%>


This will help prevent errors when agencyid is null or agencyid has a non-numeric value.

Also, are there two tables - authusers_reg and authusers ? If yes, what is the significance of these tables ?