getUser(username=username) what is that...
output it ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] Sent: Saturday, September 29, 2007 9:29 PM To: CF-Talk Subject: Creating randon username error 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289804 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4