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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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