How can I customize a friendlier client-side error mesage? 4

[ColonelBlue]

For example I get this:

Microsoft OLE DB Provider for Indexing Service error '80040e14'

Incorrect syntax near ' and )') AND (Filename LIKE '%.html' OR Filename LIKE '%.asp' OR Filename LIKE '%.htm') ORDER BY Rank DESC'. Expected STRING. SQLSTATE=42000

/search/runsearch.asp, line 199

How much can I customize/tweak a client side error and how?

Thanks in advance.

 

[Chopstik]

Put some error-checking code around the function that calls your recordset (or any code that can produce an error message like this) and then response.write out a more friendly error message. You can make it as elaborate or as simple as you wish.

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[ColonelBlue]

Thanks chopstick.
Obviously I am not an expert. Error checking code? Would you please be so kind to point me toward the right direction? Just a few examples somewhere and I can find my way.

Cheers

CB

 

[johnwm]

Try:

http://www.w3schools.com/ado/ado_ref_error.asp

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[Tarwn]

Another option would be to customize your 500-100.asp page or create a new one. You can configure what page is used as the error page in the Internet Services Manager for IIS (or something like that).

-T

 

[Chopstik]

Thanks for the follow-up, johnwm and Tarwn. I guess I should have elaborated a little more in my original response...

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill