Can't use CFGRIDUPDATE? Try this...

CFGRIDUPDATE is a great tag. Unfortunately I've never used it. It always seems like my grids are always too complex or I need to do something conditionally during the update. Fortunately there is an easy way to successfully use an editable grid and update your database accordingly. Unfortunately, the latest version of Macromedia's livedocs doesn't show you an example (for those on the slightly less advanced level of coding who need examples). Fortunately, the livedocs for CF5 does show you an example. Rather than reprint their example, I'll just link to the cfgrid version 5 documentation. Doing the update yourself is not that bad. As I stated above it allows you to perform complex and/or conditional updates (into multiple tables if necessary) and also allows you to do other things while looping over the grid (such as kick off an email if a certain deletion or update occurs).

Comments (0) | Print | Send | del.icio.us | Linking Blogs | 2811 Views