Hi Jerry: First of all thanks for your response... "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... depends on what the user selects Can you show me how ?... <cfset buildarray = ListToArray(form.assignBuildings) /> <cfset variables.lenbuildarray=ArrayLen(buildarray) /> <cfquery name="qaccess" type="ODBC"> INSERT INTO projectGeneral (?) VALUES (?) </cfquery> <cfloop> <?> </cfloop> Thanks again, -Roger
Jerry Johnson <[EMAIL PROTECTED]> wrote: 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 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 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! > > > > > > 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:1477 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
