<%
rscheck=con.execute("select * from authusers_reg where agencyid = '"& agencyid &"'")

if rscheck = "" then
response.redirect "reg.asp"
end if
%>

I have this code above.

I am looking for the script to do a check on the authusers_reg to see if there are any records matching the 'agencyid' which is MK. If there are NOT then I want it to redirect the user to 'reg.asp'.

Would this code work?

Thanks.

Picco

www.crmpicco.co.uk

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

First of all... Which type is your agencyid? Do you need the extra ' signs?

Moreover the SELECT statement could look a bit different; e.g. you could use the COUNT function to count the rows matching the condition, and then check to see if this number is above 0.

It is something like... ... and then you should be able to retrieve the value something like this...
You might have to remember that you should do some conversion, if you are comparing the value to some integer. The code you posted will not work as far as I know.

Hope it helps.

Jacob.

Try the code below
 <%

set rscheck=con.execute("select * from authusers_reg where agencyid = '"& agencyid &"'")

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

Shibu Narayanan
Software Associates

;;;Would this code work?
No, an element within the object can be compared to a "" not the object its self

You say:
;;;If there are NOT then I want it to redirect the user to 'reg.asp'

Follow Shibu's suggestion however change:
if not rscheck.eof then
response.redirect "reg.asp"
end if

To:
if rscheck.eof then
response.redirect "reg.asp"
end if


Wind is your friend
Matt