First of all what is assignBuildings and what does it hold, and secondly your code needs tweaking.
There is no reason to place #'s in your code when doing assings. <cfset buildarray = ListToArray(form.assignBuildings) /> <cfset variables.lenbuildarray=ArrayLen(buildarray) /> Now as ListToArray Returns an array you don't need to declare it as an array to begin with either. Regards, Andrew Scott Quote of the Day: A man makes inferiors his superiors by heat; self-control is the rule. - Ralph Waldo Emerson -----Original Message----- From: ambient [mailto:[EMAIL PROTECTED] Sent: Saturday, 22 October 2005 12:33 AM To: CF-Newbie Subject: ListToArray...how to? I have this stub of code that I want to complete. I need to get the values of the variable (form.assignedBuildings) and plug it in my SQL dbase table with called projectbuildings (columns: counter, projectno, building). How do I complete this? Help! <cfset buildarray = ArrayNew(1)> <cfset buildarray = #ListToArray(form.assignedBuildings)#> <cfset variables.lenbuildarray=#ArrayLen(buildarray)#> Thanks. -roger --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1475 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
