This is an excellent and useful tool! I added a query at the top, to look up the table names in the database and put them in a drop down list because I can never remember the exact names of the tables.
It uses the query: <cfquery datasource="#form.dsn#" name="gettables"> SELECT name FROM sysobjects WHERE xtype='u' and not(name = 'dtproperties') </cfquery> Thank you Clint for making this available to us all. It's going to save me time. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -----Original Message----- From: Clint [mailto:[EMAIL PROTECTED] Sent: Saturday, 29 March 2003 1:33 AM To: CF-Talk Subject: Re: Form Building software Here is my little form builder. I just want to reiterate - all this does is build the form. It does not build error checking, add queries or anything else at this point. I am going to enhance this form builder (I too, get tired of building the same old stuff over and over) and this will be added to my sql tool. http://www.fishermenstudios.com/downloads/formbuilder.zip there is a readme.txt, a stylesheet and formbuilder.cfm inside this zip file. The code is not encrypted and is provided free of charge. Also, this currently only works with SQL Server. Clint ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

