below I have a code that creates a new password, checks for duplicates and creates a new one if duplicate....then stops.
The chances of duplicates are slim afterwards but wouldn't there be a way to loop until unique?
Not sure how to do this.
<cfquery name="verifynewPW" datasource="#application.DSHome#" username="#application.dbuserHome#"
WHERE password =<CFQUERYPARAM Value="#newpword#">
<cfif verifynewPW.RecordCount IS not 0 >