1 - dont use cfinsert - use straight sql insert statement in a cfquery, and there may be an issue with the db or form design.......
But sounds like looping over the list of form field values will be the way. Certainly some one more bright has a a more creative way - but that would work. ----- Original Message ----- From: "Douglas Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 13, 2001 7:11 PM Subject: Re: How do you insert 10 form fields into one database field? > Why do they not have seperate naming conventions in your form? Are you > saying there is just one form field named phonenumber and the customer types > 10 different numbers into it? > > > Doug > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, December 13, 2001 6:06 PM > Subject: How do you insert 10 form fields into one database field? > > > > Whats the best way to insert 10 form fields into one field in the server > > database via CFHTTP. > > > > Is it better to: > > > > 1. Do 10 separate insert statements or > > > > 2. Use just CFINSERT and let it occur autmatically or > > > > 3. Use a loop statement. > > > > Field name on form is "phonenumber", there are 10 different ones, i.e. > > > > phonenumber1 > > phonenumber2 > > phonenumber3, etc, etc > > > > And all need to post into the field 'phonenumber' in the database as > > separate records (unique rows/records). Am also inserting with each number > > the custid so it a join can occur to the main customer table. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists