29 May 2007 Update: Mostly GUI Changes

I added a textfieldsize variable to control the size of the text fields and made the column info query sort based on alias so you have a little more control over the order in which the fields are presented to the user. I also added a nowrap to the column alias table cell so that it doesn't break in odd places. hth. mf

Customization Note

If you want or need to add additional fields to the create/edit page (edit.cfm), just be sure to add the corresponding column name to the strawberry_fields hidden form field. strawberry_fields lists the field names which are used in the update/insert statement. For example...

<tr>
<td valign="BOTTOM">Category</td>
<td valign="BOTTOM">
<cfselect name="cat_id" size="1" query="qCat" value="cat_id" display="cat_txt" required="Yes"></cfselect>
</td>
</tr>
<input type="hidden" name="strawberry_fields" value="cat_id">

hth

24 Apr 2007 Update

The most current version fixes bugs in the update and create page that didn't process hidden fields properly. I'm using this in production on an intranet with 3500 users and 100k pages/day and it seems to be holding up pretty well and without complaints from the users. The next big step will be to swap out the text boxes for text areas and add in validation for required fields and datatypes which may require adding a field to the database table. Be sure to check out the readme.txt for details. Peace. mf

BlogCFC was created by Raymond Camden. This blog is running version 5.5.006. | Protected by Akismet | Blog with WordPress