I am very new to cold fusion and have been looking at the CFC info and was wondering how to write a CFC to add information to a database. I think having functions to do this would save a lot of time because they are reusable and eliminates the need to rewrite several pages when the database structure is changed. We defined the tables like so; Table addressbook Id (tinyint 4 required) Firstname (varchar 50) Lastname (varchar 50) Address (varchar 100) City_id (varchar 50) State (char 2) Zipcode (varchar 10) I have a good example for writing a database query but not for adding records. I assume my return value would consist of a Boolean value which would verify a successful (or not) update. Can you please give me some guidance on this?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
