Re: [CFCDev] CFMX SQL Server Code Generation Tool

[Barnaby Relph]

It's down for me too, although I sound this in an earlier mail from Joseph which may explain it:   "Others:    If you find the server response a little slow,  it maybe my server's Internet connection. It runs off a broadband 385K wireless connection. At times the network response is not consistent."   I'll try later.   Barny   ----- Original Message ----- From: Adams, Frank To: [EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 11:28 AM Subject: RE: [CFCDev] CFMX SQL Server Code Generation Tool The site seems to be down. Is there any way you could send the program via email?   Frank -----Original Message----- From: Joseph Flanigan [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 12:46 AM To: [EMAIL PROTECTED] Subject: [CFCDev] CFMX SQL Server Code Generation Tool General Availability of CFMX SQL Tool Code  Generation Tool, Version 1.4+ MediaFirm's CFMX / MS SQL Server Tool is released for general use and available for download. Download: http://www.switch-box.org/CFSQLTool/download This tool sets a milestone for code generation!  It is packed with features that will save many hours of coding and debugging. CFSQLTool is a set wizards for CF and SQL code generation and execution using SQL Server meta-data from tables, views and stored procedures   - generates CFC, cffunctions and CF namespace variables   - generates SQL and executes stored procedures   - general purpose SQL batch tool for running SQL scripts. License  is GNU-GPL, Open Source, without $ charge. The download is a zip of about 200K.  -- There is lots of code to explore. Code generators require CFMX and SQL Server 2000. It uses CFFactory for data source name selection. The SQL Batcher feature can run with any CF data source. Minimum system is Windows 2000, IIS, CFMX 6.1 developer edition and SQL Server MSDE. The wizards include:    SQL Batcher - something like Query Analyzer but uses CFQuery.    Table Wrapper - CFC generator with cffunctions for CRUD List and Actor using CFquery.    Table Wrapper application - Generates a CF application that uses the table wrapper CFC    Stored Procedure Suite - Generates CRUD stored procedures and loads procedures to DB, better than Query Analyzer    Stored Procedure Wizard - Show, Run, Drop Procedures.                                            Generates CF name spaces defined by procedure variables                                  Generates a CFC for stored procedures with cffunctions used cfstoredproc   Table Defined Name Spaces Wizard - bangs out a collection of CF variable names defined by SQL Server data definitions There are several pages of documentation including a SQL name spaces style guide. Below is an image of the Table Wrapper Wizard Selector form. Its allows designing a suite of queries that generates a CFC using simple check boxes. It shows more detail about the table's constraints than some other DB IDE tools.  The wizard counts generation iterations. This makes it easy to design multiple queries that can be cut and pasted into the Wrapper CFC.   The Stored Procedure Suite Wizard uses a similar selector form, but generates stored procedures instead. If you do stored procedures, it will not believe how easy it is do them with this tool! SQL Batcher is a versatile tool just because it is easy to run SQL and see a CFDump of the results. SQL Batcher will load and run a .SQL batch file. In the download is an example contacts DB SQL batch file that SQL Batcher can run to build the data base with tables and views. It runs the same in Query Analyzer as it does with SQL Batcher. The result report, counts each batch block, reports the execution time, code block executed and results.     ------------------------------------------ Switch_box www.Switch-box.org MediaFirm, Inc. PO Box 2171 Loveland, CO 80539 [EMAIL PROTECTED]