default page for duplicate values

[wouter]

Hello,

At this point, when i try to submit data into my database, and they contain duplicate values, i get an CF-error message. You know, it's the big white screen with a lot of text. I would like to create my own error-message, so the users know what the error-message is about. The white screen can be a little confusing for non-technical user. Does anyone know how i can make this work?

Wouter [sig][/sig]

 

[Bromrrrrr]

You could use cftry/cfcatch like:

<CFTRY>
<CFQUERY NAME=&quot;MyQRY&quot; DATASOURCE=&quot;MyDSN&quot;>
*insert query that might go wrong*
</CFQUERY>
<CFCATCH TYPE=&quot;database&quot;>
*insert error handling*
</CFCATCH>
</CFTRY>

In the cfcatch tag you can redirect users to a general error-message or you could use the cfcatch variables to direct them to a more specific error message. Read the cfdocs on cftry/cfcatch for more information on cfcatch variables.

Hope this helps,

Brommrrrrr [sig][/sig]