[thelist] Web Forms to Access DB?

[mrg]

Rudy,
Excellent point, as always. 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>

Thanks,
matt

> From: "rudy" <r937 at interlog.com>
> insert username/password
> if database constraint violated, issue error
> 
> let's say that the incidence of somebody trying to add the same
> username/password occurs one out of every hundred attempts
> 
> if you are using script logic, you will issue 199 database calls
> 
> if you let the database constraint handle it, you will only ever issue 100
> calls