Hi guys,

Am getting a strage error. Running the code below, I get a value of
'INVALID' inserted into my username column (MSSQL) rather that something
like 'LIK2007'?

Can any one see what I may be doing worng?

<!--- set default username and password --->
<cfset valid_username = false>
                        
<cfloop condition="valid_username EQ true">
        <cfset username = trim(left(uCase(arguments.lname), 3)) &
randRange(1000, 9999)>
                <cfset getUser = getUser(username=username)>
                <cfif getUser.recordcount EQ 0>
                        <cfset valid_username = true>
                </cfif>
</cfloop>

Thanks heaps
Mike



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289803
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to