I was going to say something similar to Justin. I got to the point where i was hating the drudgery of writing the forms. So i wrote a little app that interrogates a database table and writes a form that has an input field for every column in the table, making the appropriate input type for teh column spec.
It doesnt create a perfect form, but it does the vast majority of the work, then i can just tweak the form a little and its ready to go. Instead of taking an hour to write a form that i've been putting off doing (i'm a talented procrastinator), it takes a few seconds to generate the form automatically and a few minutes for the tweaks to make the changes to accommodate what hasn't been generated by the code writer. Since the vast majority of the forms I write are for input/edit to tables, that takes away most of the form drudgery for me, and have been much happier at my work ever since. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 9/25/07, Justin Scott <[EMAIL PROTECTED]> wrote: > > Now that I got that off of my chest, does anyone know of > > some nifty-cool program/guy in a dark room halfway around > > the world/magic spell that would help with most of the > > more mundane aspects of the process. > > Our company specializes in web sites with CMS for the clients to manage > all their own data. Everything is custom, and we got tired of building > admin forms to manage the data. So, several years ago a couple of the > guys spent some time and created an admin generator that we point at the > database once it's created. It asks some questions, then creates all of > the search/list/add/edit (with input validation, etc)/delete/export code > for a given table in the database. It even handles relationships and > foreign key constraints. Makes building a CMS very fast and simple. We > have other tools for forms on the front-end of the site, but not nearly > as simple as the admin side. We keep telling management that we should > license it to other developers specifically for this reason (we hate > coding forms so much). > > > -Justin Scott | GravityFree > Network Administrator > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289371 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

