[thelist] Web Forms to Access DB?

[rudy]

> Using the database constraint method with Cold
> Fusion, are you pretty safe doing a cftry/cfcatch like this?
> <cftry>
>    <cfquery>INSERT...</cfquery>
>    <cfcatch type="database">
>        Sorry, try another username...
>        <cfinclude template="form_register.cfm">
>    </cfcatch>
> </cftry>

beauty

yes, that should work

worst case scenario, without something to "catch" the database error, the
user will probably see the raw database error -- not always a bad thing,
since it does usually indicate what the problem was (e.g. "unique
constraint on username violated") but probably too shocking for most users

rudy