Hi Andrew: First of all, thanks for responding.... "assignedBuildings" are the values the user selects from my form (from a select box) --ie: the values returned are Lexington Ave, 80th St, Annex St etc... depending on what the user selects So, if this is what I begin to use...how do I then get these values into my database? <cfset buildarray = ListToArray(form.assignBuildings) /> <cfset variables.lenbuildarray=ArrayLen(buildarray) /> I appreciate your help. -Roger
Andrew Scott <[EMAIL PROTECTED]> wrote: 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. 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! 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:1476 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
