oh !!!!! the output from getUser is a struct, not a query!
my bad. mike >getUser(username=username) > >what is that... > >output it > >.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. >Bobby Hartsfield >http://acoderslife.com > >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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289805 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
