<%
if timeoption = "option_bookings_only" then
response.write "Option"

Set rs=con.execute("select * from trip_master where agencyid = '"&agencyid&"' and status = 'TL'")
while not crm.eof
response.write ("select * from trip_master where agencyid = '"&agencyid&"' and status = 'TL'") & "<br>"
crm.movenext
wend
'response.write "NO RECORDS!"
response.redirect("bookings.asp?badlogin=true")
end if
%>

what is wrong with this syntax?

it just crashes my IIS

Picco

www.crmpicco.co.uk

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

Changed it to this:

<%
if timeoption = "option_bookings_only" then
response.write "Option"

Set rs=con.execute("select * from trip_master where agencyid = '"&agencyid&"' and status = 'TL'")
'response.write ("select * from trip_master where agencyid = '"&agencyid&"' and status = 'TL'") & "<br>"
while not rs.eof
rs.movenext
wend
response.write "NO RECORDS!"
'response.redirect("bookings.asp?badlogin=true")
end if
%>

still crashes my IIS/DB!"!!!!!!!

WTF?

Picco

www.crmpicco.co.uk

Is there any error shown?

What is the name of ASP file?
Is it bookings.asp? then you are looping in it. please take away the redirect code.

Please clear all your cache and try again.


Shibu Narayanan
Software Associates