Hi,
I have a project where I read from a SQL database fields for a qualification. One of the fields is "document path". If this field is not null, i then try and retrieve the actual document. If the document path is null, i just display the fields in typical asp fashion.

My problem is that sometimes the document path field has data, but the physical document actually isnt there, and so, the browser displays a url that does not exist and I get the "Page cannot be displayed".

I need to be able to have code that says...if the document isnt there, then treat it the same way it handles the scenario when the document path is null.

Code:
if len(trim(rslist("DocumentPath"))) > 0 then
   url="../../US/Documents/" & rslist("DocumentPath")
   Response.Redirect(url)
					
else
					
display all fields...
%>
any advice is welcome..
thankls in advance