I am currently running a random number generator and assigning it to a
variable as follows:
<cfset CompanyId = #LCase(Left(form.CompanyName,2))# &
#RandRange(100, 999)#>
The problem is that there will always be the possibility of duplication. I
would like to run a <cfquery... to extract the Company IDs from the table in
order to double check for duplication. If a duplication is found, how can I
cause the random number generator to run again and recheck for duplication
without reloading the entire page?
_____
Gary L. Alford
Manufacturing Operations Project Specialist
Bell Helicopter XWorx
Phone: (817) 280-6233 Fax: (817) 278-6233
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
I have not failed. I've found 10,000 ways that won't work.
Thomas A. Edison
_____
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
