> I was just curious as to is there a way to semi-automate > inserting/delete records. Let me explain, internally we > develop several applications that require add/edit/delete/display > records, these tasks are very repetitive and really hate to > include the same code over and over again. The only difference > is that I am performing this actions on different tables. When > I used to develop in VB I used to get my list of fields by > giving a command such as "Recordset.fields", is there a similar > function?. I am relatively new to CF, and I love it, but I just > hate doing the same steps over and over again. I am currently > reading and looking at examples of fusebox, hoping that it will > help me on simplifying my code... You certainly can automate the process of creating scripts to handle data manipulation for tables. The approach we've used is to build a script which generates other scripts, rather than to build a one-size-fits-all script for editing any table. You can download it from http://www.figleaf.com/figleafhome/cfug/cfugoct.zip. It's written to be used with SQL Server, but the approach could be used with a little modification against other databases. There's also a product called Database Blocks, which is a commercial product which does the same kind of thing, although I expect it's quite a bit more polished! I haven't used it myself, but I've heard good things about it, and it's only $79. http://www.commerceblocks.com/DATABA/index.cfm Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
