You are storing the column names in your structure, but not the values. Change this: <cfset stc_UserData["#tmpname#"] = "#tmpname#"> to this: <cfset stc_UserData["#tmpname#"] = "#Evaluate(tmpname)#"> You may need to reference the query by name, though. -David On Sat, 19 Aug 2000 00:18:58 -0400 "Bill Killillay" <[EMAIL PROTECTED]> writes: > When I run this code below I end up getting the column name in the > cfoutput > at the bottom. > > How would I get the value of that instead? I am only pulling on > record from > the db and I want to be able to load that into a structure so as to > not have > to pass around that information from screen to screen via the URL or > Hidden > Form or Session Variables. > > <cfquery name="get_user_data" datasource="#attributes.maindsn#"> > select id, cfid, member_id, member_password, > password_hint, last_name, > first_name, phone, address1, address2, city, > state, zip, country, > comments, account_active_status, date_created, terms_agreed > from member > where cfid = '#client.cfid#' > </cfquery> > > <!--- Set my default local variables that will be needed to create > the > dynamic structure ---> > <cfset num_rows = ListLen(get_user_data.columnlist)> > <cfset cnt = 1> > <cfset qry_list = "#get_user_data.columnlist#"> > > <!--- Create the structure that we are going to populate in the next > step ---> > <cfset stc_UserData = StructNew()> > <!--- Loop over the query list to populate the structure data ---> > <cfloop from="1" index="cnt" to="#num_rows#"> > <cfset tmpname = ListGetAt(qry_list, cnt)> > <cfset stc_UserData["#tmpname#"] = "#tmpname#"> > <cfset cnt = cnt + 1> > </cfloop> > > > <cfoutput>#stc_UserData.last_name#</cfoutput> ________________________________________________________________ YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
