I can't tell what you are trying to do. What does assignedBuildings have in it? where does the projectno come from?
You are going to want to use the <cfquery> tag to insert the data into the database. You are going to want to use cfloop to run the query for each record to insert. On 10/21/05, ambient <[EMAIL PROTECTED]> wrote: > 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:1474 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
