That'd be us. We have a database->CFC generator. The state of the system is never finalized - we always look for tweaks. What we have works well, but our latest version is not packaged for distribution at this moment. It generates CFCs to be run on CFMX 6.1, but it requires CFMX 6.0 to build the CFCs. A copy of the CFC generator has been updated to support 6.1 by another developer here, but he's away on a family emergency right now and I haven't seen it myself yet. It used to not work on the J2EE editions of CFMX, but I think that's been fixed. We use it to start every project and it works really well for us. It's used internally, so the FAQ is in my head and not all written down.
What it does - it uses Java to look at your datasource and get the tables and views. Then pull out the columns and their attributes to generate a CFC for each DB object. It's nice because we use Java as opposed to DB specific stored procs to get the info, so it's capable of working with many DB platforms except Access (Access doesn't state it's PK's properly). Potentially more info and an old version of the tool can be found http://buildcfcs.blogspot.com - which I'm migrating to www.smartermx.com - but it's not a billable task to maintain those, so they don't always get updated frequently. I don't have much else to say except, again, our latest version isn't packaged up currently. I'll look to get a latest rev next week when the other guy gets back and we can coordinate our builds. If there is interest, I'll post back when it's updated, or check out the site next week. t ********************************************************************** Tyler M. Fitch Certified Advanced ColdFusion MX Developer Portland ColdFusion User Group Manager http://www.pdxcfug.org http://isitedesign.com ********************************************************************** -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sean A Corfield Sent: Wednesday, January 07, 2004 11:58 AM To: [EMAIL PROTECTED] Subject: Re: [CFCDev] CFC Code generator On Jan 7, 2004, at 10:38 AM, Schreck, Thomas (PPC) wrote: > Does anyone know if a CFC Code generator exists? Yes, I know some folks on the West Coast who have built a system to generate CFCs for persistence from a database schema. I don't know what state their system is in and I don't know yet how public it is... Sean A Corfield -- http://www.corfield.org/blog/ "SOAP is not so much a means of transmitting data but a mechanism for calling COM objects over the Web." -- not Microsoft (surprisingly!) ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
