There is no reason to do a response.redirect
You can query and display on the same page if you want. Just post back to your calling page.
I do not use DTC's.
form action="myasp.asp" ...
INPUT name="inputtext"...
/form
IF request("inputtext")<>"" THEN
SET ors = ... 'get your recordset here
IF ors.eof THEN
response.write("No records selected")
ELSE
'display records here
END IF
END IF
>if I do a query which returns no records I'm setting a DTC label caption on the same page which gives the user a message. If there are results then I do a reponse.redirect to a results page.
This works but then they if they (the users) use their back button they get a series of the query pages with the no records selected message. Which they don't like.
I've tried stopping the page being cached but that doesn't seem to work.
Anyone got any suggestions or experience they could share about how to handle a query and search results.