Squidhead

Release Notes

Version 2.0.00663

Thu, April 17, 2008 3:25:00 PM GMT

Removed cfdump/cfabort combo that was occasionally called.

Files Effected

Fix Bug: default value not getting set right for non required fields

Files Effected

Fix bug: Simple applications were getting created with reference to "destory" insread of "destroy".

Files Effected

Fix Bug: default value not getting set right for non required fields

Files Effected

Version 2.0.00586

Tue, March 11, 2008 3:42:00 PM GMT

Improved messaging for linked objects. Now only the updated table will display a message instead of all of them because the message was too generic.

Files Effected

Fixed Bug 25 : http://squidhead.riaforge.org/index.cfm?event=page.issueedit&issueid=63B7DB81-F255-09CA-8F1035ED2FBECDFF. Select arguments were not being qualified with brackets in certain MSSQL stored procs.

Files Effected

Added documentation and error handling around the fact that MySql requires mode requires that the account have access to mysql.proc.

Files Effected

Updated a bit of documentation.

Files Effected

Fixed bug in MSSQL stored proc creation routine, which caused an error to be thrown whenever joined tables were used.

Files Effected

Fixed bug caused by lazily replacing all commas with a comma and a break.

Files Effected

Added smallmoney datatype to constants.

Files Effected

Fixed bug in column escaping. Bug was causing creation of linking tables to fail.

Files Effected

Fixed issue with multiple output variables in MSSQL. Basically Squidhead correctly put more than output variable into a structure, but didn't change the function output type to structure.

Files Effected

Fixed issue with multiple output variables in MSSQL. Basically Squidhead correctly put more than output variable into a structure, but didn't change the function output type to structure.

Files Effected

Increasing the timeout on the application refresher.

Files Effected

Fixed issue with multiple output variables in Oracle. The previous fix for MSSQL broke things for Oracle.

Files Effected

Fixed issue with multiple output variables in Oracle. The previous fix for MSSQL broke things for Oracle.

Files Effected

Removed cfdump/cfabort combo that was occasionally called.

Files Effected

Version 2.0.00271

Tue, November 20, 2007 6:39:00 PM GMT

Files Effected

Fixed a series of bugs preventing Squidhead from running in Linux. Mostly related to casing of components.

Files Effected

Fixing bug where generated application would not run in Linux becasue of case issue with Application.cfm file.

Files Effected

Fixed bug where MYSQL select method was ommiting prefix _ characters.

Files Effected

Added precision and scale to the metadata in order to properly handle decimal data.

Files Effected

Added configuration "settings" "IgnoreXMLCache". This feature tells squidhead to stop looking at the XML cache. It speeds up table analysis at the cost of the features of the XML cache. If you don't know what they are, then you can safely set this to true. Hopefully someday I can improve the performance of the XML cache, rendering this feature obsolete.

Files Effected

Fixing bug which caused Squidhead to truncate decimal values.

Files Effected

Adding proper decimal support to Oracle. That was shockingly easy.

Files Effected

Added Oracle application to the list of applications that gets unit tested by default.

Files Effected

Fixed bug in CFUnit tests that caused it not to work with Oracle.

Files Effected

Altered the format of generated cfstoredproc calls. It was based on a suggestion by Nathan Mische http://www.mischefamily.com/nathan/. Instead of having the conditional decide whether or not the proc would pass null, the change pipes the conditional right into the null parameter. Thanks Nathan, that's very elegant.

Files Effected

Refactored database analysis for performance. Reduced the cost of comparing to the XMLCache by about 50%. This should lead to a 25% to 33% reduction in time for builds depending on your configuration.

Files Effected

Version 2.0.00254

Mon, November 05, 2007 12:12:00 AM GMT

Made a change that prevented Squidhead from creating lists of linking tables in the business object of a table linked by a linking table. Why? Well since those linking tables don't really store information in their own right, why include them.

Files Effected

Added Oracle database inspection.

Files Effected

Fixed bug caused by ORACLE timestamp meaning something very different from other database timestamps.

Files Effected

Checking in ORACLE code. It doesn't work just yet. I have to spend some time thinking about how to implement this feature.

Files Effected

Seemingly have Oracle Stored procedure creation working.

Files Effected

Seemingly have Oracle Stored procedure creation working.

Files Effected

Made a few changed to make Oracle work.

Files Effected

Perfecting Oracle support.

Files Effected

Made changes to support Oracle.

Files Effected

Made changes to support Oracle.

Files Effected

Made changes to support Oracle.

Files Effected

Files Effected

Oracle components pass all unit tests. Squidhead now officially supports Oracle. Queue bug reports in 3....2...1....

Files Effected

Made DAO's and gateway's take db parameters as init arguments. But they are defaulted to application values so as not to break backwards compatibility.

Files Effected

Added coldspringGenerateConfig step. Squidhead now generates Coldspring config files.

Files Effected

Files Effected

Version 2.0.00227

Tue, October 23, 2007 1:01:00 PM GMT

Fixed bug that caused updates to child rows to fail due to a missing DAO reference.

Files Effected

Fixed a bug that caused delete procs for tables with an active column to deactivate all rows, not just the target row.

Files Effected

Fixed a bug that caused insert and update procs in MySQL for tables with an active column to overwrite all rows, not just the target row.

Files Effected

Added more generated comments to the dynamic business objects.

Files Effected

Fixed bug where unique constraints were not honored for tables in Mysql in active/deactive mode.

Files Effected

Fixed bug where order by was not working properly in stored procedures in MySQL.

Files Effected

Added option in fkCrazy template to alter the value of the submit button.

Files Effected

Added table or object name to the class of edit forms. So that you can create css based on your objects.

Files Effected

Made sure that ui cflocations in fkcrazy template were using appendToken to false.

Files Effected

Fixed bug caused by direct reference in baseBusiness Object to the form scope, instead of the passed in reference to the form scope.

Files Effected

Added checksumming feature to table analysis. Now certain operations only run when they need to be on a table by table basis. For example if you don't change any tables, then the auto generated stored procedures don't have to be altered, and the custom tags (which are based on the tables not the procs) don't need to be altered. This can be overridden by using the force refresh option, deleting the tables.xml file, or deleting the checksum for a particular table from the tables.xml file. This results in about a 25% reduction in run time for a moderately complex table. More if you have a lot of foreign keys, less if you don't.

Files Effected

Made a change to allow foreignKeySelector custom tag to handle non-nullable fields gracefully.

Files Effected

Added documentation on how Squidhead reacts to certain database features including foreign keys and unique constraints.

Files Effected

Added Riaforge publisher. Added SVN History publisher. Should be last step to one step build.

Files Effected

Updated pdfgenerator

Files Effected

Version 2.0.00225

Tue, October 23, 2007 1:00:00 PM GMT

Fixed bug that caused updates to child rows to fail due to a missing DAO reference.

Files Effected

Fixed a bug that caused delete procs for tables with an active column to deactivate all rows, not just the target row.

Files Effected

Fixed a bug that caused insert and update procs in MySQL for tables with an active column to overwrite all rows, not just the target row.

Files Effected

Added more generated comments to the dynamic business objects.

Files Effected

Fixed bug where unique constraints were not honored for tables in Mysql in active/deactive mode.

Files Effected

Fixed bug where order by was not working properly in stored procedures in MySQL.

Files Effected

Added option in fkCrazy template to alter the value of the submit button.

Files Effected

Added table or object name to the class of edit forms. So that you can create css based on your objects.

Files Effected

Made sure that ui cflocations in fkcrazy template were using appendToken to false.

Files Effected

Fixed bug caused by direct reference in baseBusiness Object to the form scope, instead of the passed in reference to the form scope.

Files Effected

Added checksumming feature to table analysis. Now certain operations only run when they need to be on a table by table basis. For example if you don't change any tables, then the auto generated stored procedures don't have to be altered, and the custom tags (which are based on the tables not the procs) don't need to be altered. This can be overridden by using the force refresh option, deleting the tables.xml file, or deleting the checksum for a particular table from the tables.xml file. This results in about a 25% reduction in run time for a moderately complex table. More if you have a lot of foreign keys, less if you don't.

Files Effected

Made a change to allow foreignKeySelector custom tag to handle non-nullable fields gracefully.

Files Effected

Added documentation on how Squidhead reacts to certain database features including foreign keys and unique constraints.

Files Effected

Added Riaforge publisher. Added SVN History publisher. Should be last step to one step build.

Files Effected

Updated pdfgenerator

Files Effected

Version 2.0.00222

Tue, October 23, 2007 12:39:00 PM GMT

Fixed bug that caused updates to child rows to fail due to a missing DAO reference.

Files Effected

Fixed a bug that caused delete procs for tables with an active column to deactivate all rows, not just the target row.

Files Effected

Fixed a bug that caused insert and update procs in MySQL for tables with an active column to overwrite all rows, not just the target row.

Files Effected

Added more generated comments to the dynamic business objects.

Files Effected

Fixed bug where unique constraints were not honored for tables in Mysql in active/deactive mode.

Files Effected

Fixed bug where order by was not working properly in stored procedures in MySQL.

Files Effected

Added option in fkCrazy template to alter the value of the submit button.

Files Effected

Added table or object name to the class of edit forms. So that you can create css based on your objects.

Files Effected

Made sure that ui cflocations in fkcrazy template were using appendToken to false.

Files Effected

Fixed bug caused by direct reference in baseBusiness Object to the form scope, instead of the passed in reference to the form scope.

Files Effected

Added checksumming feature to table analysis. Now certain operations only run when they need to be on a table by table basis. For example if you don't change any tables, then the auto generated stored procedures don't have to be altered, and the custom tags (which are based on the tables not the procs) don't need to be altered. This can be overridden by using the force refresh option, deleting the tables.xml file, or deleting the checksum for a particular table from the tables.xml file. This results in about a 25% reduction in run time for a moderately complex table. More if you have a lot of foreign keys, less if you don't.

Files Effected

Made a change to allow foreignKeySelector custom tag to handle non-nullable fields gracefully.

Files Effected

Added documentation on how Squidhead reacts to certain database features including foreign keys and unique constraints.

Files Effected

Added Riaforge publisher. Added SVN History publisher. Should be last step to one step build.

Files Effected

Version 2.0.00223

Tue, October 23, 2007 12:39:00 PM GMT

Fixed bug that caused updates to child rows to fail due to a missing DAO reference.

Files Effected

Fixed a bug that caused delete procs for tables with an active column to deactivate all rows, not just the target row.

Files Effected

Fixed a bug that caused insert and update procs in MySQL for tables with an active column to overwrite all rows, not just the target row.

Files Effected

Added more generated comments to the dynamic business objects.

Files Effected

Fixed bug where unique constraints were not honored for tables in Mysql in active/deactive mode.

Files Effected

Fixed bug where order by was not working properly in stored procedures in MySQL.

Files Effected

Added option in fkCrazy template to alter the value of the submit button.

Files Effected

Added table or object name to the class of edit forms. So that you can create css based on your objects.

Files Effected

Made sure that ui cflocations in fkcrazy template were using appendToken to false.

Files Effected

Fixed bug caused by direct reference in baseBusiness Object to the form scope, instead of the passed in reference to the form scope.

Files Effected

Added checksumming feature to table analysis. Now certain operations only run when they need to be on a table by table basis. For example if you don't change any tables, then the auto generated stored procedures don't have to be altered, and the custom tags (which are based on the tables not the procs) don't need to be altered. This can be overridden by using the force refresh option, deleting the tables.xml file, or deleting the checksum for a particular table from the tables.xml file. This results in about a 25% reduction in run time for a moderately complex table. More if you have a lot of foreign keys, less if you don't.

Files Effected

Made a change to allow foreignKeySelector custom tag to handle non-nullable fields gracefully.

Files Effected

Added documentation on how Squidhead reacts to certain database features including foreign keys and unique constraints.

Files Effected

Added Riaforge publisher. Added SVN History publisher. Should be last step to one step build.

Files Effected

Version 2.0.00193

Wed, October 17, 2007 4:56:00 AM GMT

Most of the changes here have to do with Foreign Keys and the FKCrazy template. Squidhead can now detect many to many relationships across [table]To[table] assuming that their are foreign keys in the tableToTable table and they are named the same as the primary keys in joined tables. It allows you to add and delete those relationships. If you actually read this, and this doesn't make sense drop me a line. I'll record another video to explain it. (I really don't know how to explain it.) If you are using the FKCrazy template, make sure you replace the baseBusiness.cfc.

Unique constraints are now recognized by Squidhead. If there is a unique constraint on a table, it writes a read by column procedure automatically, and can be used in business object instantiation.

Made sure that all columns in a stored procedure is referenced wrapped in qualifying terms.

Version 2.0.00183

Fri, October 12, 2007 6:38:00 PM GMT

Updated a fair amount of documentation

Refactored a few things to make code base more miantainable.

Fixed bugs related to cfimage anf fonts on different OS's

Added a new feature with foriegn keys: child autowiring. It's a bit hard to explain but let me try explain. Let's say you have a table entry and table comment. Comment contains a foreign key to entry, denoting that comments are many to one children of entry. When you view the read method for entry, the child comments will be displayed. Additionally the option to add a comment to entry with the comment form will be displayed. If you actually read this, and it doesn't make sense drop me a line, it's a really cool feature that's hard to explain.

To experiment with child autowiring, add the following to your config file:

Note the changes are include swapping cfc_business_dynamic in for cfc_business and chaning the application template to "fkCrazy" cause it really is fkCrazy to do this. If you are going against an already made squidhead application make sure that you do one of two things: delete your business cfc directory or change all of the inheritance so that the top level business objects inherit from their lower counterparts.

Version 2.0.00164

Mon, October 08, 2007 8:15:00 PM GMT

Only necessary for MYSQL users

Made image crud work for MySQL. Requires IsImage to be manually set on the blob column in the XML disk cache. This can be found in the tables.xml in your generated application's sql folder.

Configuration generator works for MySQL now.

Default configs have been slightly tweaked to work better.

Doc's slightly updated.

Version 2.0.00156

Mon, October 08, 2007 4:32:00 PM GMT

Ignore release. Testing publishing mechanism.

Version 2.0.00159

Mon, October 08, 2007 4:32:00 PM GMT

Ignore release. Testing publishing mechanism. No different for users than 155.

Version 2.0.00155

Sun, October 07, 2007 11:32:00 PM GMT

Added a little extra CRUD for images. Made refreshing the application a default step.

Version 2.0.00150

Sat, September 29, 2007 11:01:00 PM GMT

Fixed more bugs with MySQL support. Added more user feedback on adds and updated to the UI and custom tag layer.

Version 2.0.00147

Thu, September 27, 2007 6:52:00 PM GMT

By adding MySql support I attracted Mac users to give Squidhead a try. Russ Johnson found a number of bugs that crop on a Mac. Most were because I missed a few "\"'s that should have been "/"'s. Plus I might have discovered a CFImage bug on CF 8 for Mac OSX.

Thanks, Russ, for finding the bugs, and forcing me to get my Mac Mini up an running.

Version 2.0.00123

Sun, September 23, 2007 6:28:00 AM GMT

New features:

* CF 8 features can be turned off if application will not be running on a CF8 server.

Deprecated Features:

Removed Features:

Requirements:

Notes:

Old versions of Squidhead still available at http://www.numtopia.com/squidhead.

Version .9.9.2

Fri, July 20, 2007 4:11:00 AM GMT

Overzealous refactoring led to bugs when a stored procedure returned multiple results.

Version .9.9.1

Thu, July 19, 2007 2:14:00 AM GMT

Mostly bug fixes. Who knew adding threading would be so hard. Also fixed an issue with stored procedures with "fake table names." Basically when "usp__action isn't a table, it was throwing an error. This is wrong behavior.

Version .9.9.0

Tue, July 03, 2007 10:21:00 PM GMT

A whole bunch of little things: Forced Squidhead application scope to refresh on everypage call. Forced Squidhead application to be unique to the file path on the server. Added better comments for generated functions. Added optional CF8 threading for performance improvement. Only happens if config['settings']['useColdFusion8Features'] = TRUE. Which is set by default to false.

Version .9.8.9

Wed, June 27, 2007 10:36:00 PM GMT

In my haste to get the new features out today, I created a bug. Specificly, BUG 19. This is now fixed.

Version .9.8.8

Wed, June 27, 2007 5:53:00 PM GMT

Added a feature: With the config flag - config['settings']['generateStoredProcedureFiles'] set to true, Squidhead will write a sql file for every stored procedure containing a drop procedure, create procedure and a grant permission. Caught two minor bugs: One was in the search stored procedure creator. It wasn't working properly depending on your column order. The other was in the part that writes to stored procedures to disk. It wasn't as up to date at the rest.This has been fixed.

Version .9.8.7

Tue, June 26, 2007 8:08:00 PM GMT

Note: This will definitely require you to reset the application scope of your installation of squidhead. Call the index.cfm page of squidhead with the url variable resetApp=true. Additionally, you will want to update your baseBusiness.cfc's. As they have been changed, and I don't want to update them automatically. Corrected stored procedure process to only create foreign key related tables if they are appropriate. This creates less stored procedures and is a little neater. Further corrected behavior of bit fields in the application. They now cause the UI to create a radio box for them instead of a text box. Also did a bunch of refactoring with an eye towards performance. I changed the unit testing component to test that all the UI components call be called with out throwing an error. It's not an especially thorough test, but it does catch a lot of errors for me. Finally, I changed the unit test calling page to be usable for the simple application type. Basically many of these changes were due to the fact that one user of the application was running it against a much larger database then I was testing with. Your mileage with performance updates may vary.

Version .9.8.6

Sat, June 23, 2007 5:46:00 AM GMT

Tweaked application configuration. Fixed Configuration documentation. Fixed issue 18: Default bit values in DAO create / update are not set to boolean values Refactored, and slightly improved the speed due to a suspected performance issue which ended up being due to ColdFusion server monitoring being enabled. This isn't a problem with Coldfusion. The results are to be expected.

Version .9.8.5

Tue, June 05, 2007 11:54:00 PM GMT

Couple of Minor fixes this time around. Fixed a bug where Squidhead was referring to ID instead of the actual identity column of the table. Added settings to allow for custom CSS. Refactored a few things. Altered foreign key procedures to create appropriate joins. Fixed an error where in active/deactive mode the delete method was changing the createdon instead of the updatedon. Fixed requirement for the identity key to be passed back into the business custom tag template, because the business object already contain a value for it. Made the version number of Squidhead appear in the comments of a stored proc. Altered the menus on the ui framework patterns.

Version .9.8.4

Fri, May 25, 2007 4:55:00 PM GMT

Fixed a slight bug with simple/versus business objects. It was forcing business objects despite explictly turning them off.

Version .9.8.3

Thu, May 24, 2007 5:53:00 PM GMT

Another big feature added, with some smaller updates. Squidhead now generates it's own CFUnit tests. Currently they only test the CRUD for tables with identities in the DAO's, but in the near future I will be looking to expand these out a little further. Additionally this testing rig supports user defined tests as well. If you place your tests in the test directory, then they will be added to Squidhead's tests the next time Squidhead is run. This feature will require CFUnit. Also: Altered the way file locations were handled. Instead of forcing the file locations to be set in every config, I added a default file configuration that handles setting up directories relative to the file output, if those directories haven't already been setup in the user's config. Refactored a bunch of things, and fixed a few bugs. Based on issues that were revealed by unit testing. Fixed a bug with stored procedures with the word "as" in the comments.

Version .9.8.2

Mon, May 21, 2007 3:39:00 AM GMT

Refactored some bugs. Added some more documentation. Added support for custom UI's using config['settings']['applicationTemplate']. Deprecated config['settings']['useBusinessObjects']. Same results can be achieved by setting config['settings']['applicationTemplate'] to business.

Version .9.8.1

Tue, May 15, 2007 6:20:00 PM GMT

Fixed a bug in Active table creation. Updated documentation.

Version .9.8

Fri, May 11, 2007 6:57:00 PM GMT

Added a huge feature: Foreign Key support.

Summary: Input forms will display a select box of appropriate values for foreign keyed fields.

List and Read UI components will show an appropriate column from the foreign table instead of the local table value.

It's bound to be really buggy, I did try and take it through its paces though. In any case use with caution.

Expect a .9.8.5 release with some documentation too.

How this works: For every table a "foreign key label" is computed (The second column in the table.)

For Display New StoredProcs are generated specifically a select_with_FK and a list_with_fk. These are generated as a select or list operation with all of the correct joins in place, and the foreign key's column in the displayed table being replaced by the "foreign key label" of the linked table. These with_fk procs are then used by the UI display widgets instead of the default select and read items.

For Editing A new storedproc was added that allowed for a quick retrial of a query of ID and "foreign key label". This is in turn used by a custom tag that will display a select box for foreign keyed columns.

Thanks to Antonio Vivas and Karen Leary, both at Wharton for pushing this feature, and giving an elegant idea for how to implement it.

Version .9.7.1

Wed, May 09, 2007 6:51:00 PM GMT

Slight bug in the business object stuff. Fixed.

Version .9.7

Wed, May 09, 2007 3:13:00 PM GMT

Two major changes were added, both are optional to use.

  1. Added a business objects layer that sits above the DAO. You pass it an instance of a DAO, and it handles a few operations out of the gate for you, like not having to determine if an object exists and needing to decide between creation and updating. It was championed by Dave Konopka, and it's pretty good stuff. You can use it by setting:
  2. Rewired the generated custom tags and templates to optionally use the new business layer. You can use this by setting:
  3. Added an optional XML based disk cache of the structure of the database and stored procedures. Currently you can do two things with it.
    1. Set an orderby using SQL notation that will affect the default list functions.
    2. Set a Display name for database fields that will affect the labels on the CRUD UI components.
    4. It's important to note that once you turn this on, You'll no longer be updating from the database. So you don't want to use this until your database model is complete. You can use this by seting:

Version .9.6

Wed, April 18, 2007 8:21:00 PM GMT

Fixed Issue #17. Squidhead now looks to stored procedure parameters to determine if the calling function arguments that correspond to the params are required. Up until now, we were looking at the table - IsNullable for that. Added an extra method to the gateway. Now gateways will also have a "search" function that allows any column or group of columns to be passed in and searched. So if you wanted to search for all firstname = 'Terrence' and all lastname = 'Ryan' you can do that. Varchar fields use like for matching, while all other fields look for an exact match. Also fixed a bug in the delete stored procedure created for a table with an "active" column.

Version .9.5

Fri, April 13, 2007 3:21:00 AM GMT

Fixed bugs dealing with multiple selects in stored procedures. It was over-counting selects because of the word "select" in comments and stored procedure name. Fixed through the magic of regular expressions. Fixed bug associated with reserved words. They were using "find" operations, instead of finding exact words.

Version .9.4

Thu, April 05, 2007 4:46:00 PM GMT

Fixed an issue with unicode char and varchar fields being reported as double their length (which caused issues around the upper limit of their acceptable length.) (Thanks John H.) Also reset CFC output=false, to reduce whitespace in the generation process. (Which speeds it up a bit.)

Version .9.3

Tue, April 03, 2007 5:47:00 AM GMT

Updated Configuration reference in Installation Documentation. Updated FAQ's. Added first pass of validation to Custom Tags in created application. (Enforces required attributes.) Added exclusion prefix to configuration, allowing all tables with a given prefix. (Thanks to Mark Ireland for the suggestion.) Added exclusion list to configuration, allowing a list of tables to be excluded from scaffolding.

Version .9.2

Fri, March 30, 2007 4:45:00 AM GMT

Responded to two responses to issues with this update. 1. Fixed guid length bug, reported in issue 15. 2. Added enhancement which allows for delete operation to be replaced with action that marks records as inactive, instead of deleting them from the database. Woooooo fun stuff.

Version .9.1

Tue, March 27, 2007 8:26:00 PM GMT

Support for multiple OUT variables from Stored Procedures have been added. Support for multiple results sets from Stored Procedures have been added. In both cases when more than one result (either more than one output variable, or more than one query) is possible for a given stored procedure, the function that wraps it returns a struct containing all of the items. Made slight changes to the custom tags, which allow them to be slightly more reusable. Added an override-able setting for default cffunction access attribute. By default it is "public" but you could make all of the functions be "remote" if you were say... working on a Flex App for the front end.

Version .9.0

Fri, March 23, 2007 3:12:00 AM GMT

Modified configuration routine to default many of the settings to make old config files work without throwing errors. Isolated much of the MS SQL specific code to start allowing for other database providers. Modified Custom Tag creation to make list, read, and form customs tags more portable. Altered default behavior for user imported stored procedures. Now function returns type "any" to accommodate stored procedures that return a query, or no value. Figured this was a good compromise. Fleshed out the sql variable type list.

Version .8.9

Thu, March 22, 2007 1:39:00 AM GMT

Fixed a few bugs. Added additional support for SQL 2005.

Version .8.8

Mon, February 26, 2007 9:25:00 PM GMT

Fixed a few bugs. Cleaned up support for a few data types (bit, float). Make sure you update your config files from the new copy of sample.cfm.

Version .8.7

Mon, February 19, 2007 3:33:00 AM GMT

Fixed some issues with Number data types.

Version .8.6

Thu, February 15, 2007 5:09:00 AM GMT

Nothing major just a few slight improvements to performance, and whitespace reduction.

Version .8.5

Wed, February 07, 2007 10:39:00 PM GMT

Another day, another buttload of issues.

A number of issue were revealed using the Northwind Database. Thanks for pointing them all out, Chad. (No sarcasm).

Images datatypes from the database were causing errors. They now gracefully fail to display. Will think about how to deal with images in upcoming releases. (Fixed Issue 7)

Tables or views with spaces caused all sorts of odd failures. Long story short, spaces are removed spaced table and view names in storedprocs cfc's and customtags. (Fixed Issue 6)

The sample.cfm was missing a default value for binary data.

Version .8.4

Wed, February 07, 2007 10:10:00 AM GMT

Fixed issue 5.

Removed restriction against underscores in table names.

Cleaned up behavior of image field in AutoCrud portion of application.

Version .8.3

Tue, February 06, 2007 10:36:00 PM GMT

Yeah, so I'm not so good with the making the code good.

Fixed issue 4.

Added ability to output created application to a subdirectory of output folder.

Updated documentation.

Added comment headers to the stored procedures.

Version .8.2

Mon, February 05, 2007 9:08:00 PM GMT

Fixed issues 1, 2, and 3.

Version .8.1

Mon, February 05, 2007 1:10:00 PM GMT

I uploaded a few fixes to bugs that would only allow themselves to be discovered AFTER I uploaded to RIAforge. The included Edit/Add New form was throwing exception because it was appending ID to the table name for the identity field instead of referencing the actual identity field.