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. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
