ColdFusion CRUD

Question

For quite a long time now, I've been trying to write and have been in search of "a really good" CRUD application. Don't get me wrong - I didn't say "The ultimate" CRUD application. Just one that could be rated 1st class.

What I'm saying is: Please don't respond to this plea with an answer like "Well, every situation is different..."

Q: Is there a blog post or something in the Adobe documentation that shows CRUD on a one-to-many relationship (Header/Detail), that uses web standards css (instead of tables), that uses best practices (CF9 has changed so many things now: scripted components, ORM), that uses the latest UI techniques (jQuery or some of the built-in AJAX features of CF9), that has a nice front-end (a nice looking header and background along with some pretty buttons)?

I know that's a lot to ask, but such is my quest. A good example of a one-to-many relationship is the city/state xml files built into the Spry examples. There are 23,000 cities in the sample xml files, so I think that's better than just using random data.

Answer 1

I'm not really sure what you're asking, but I just want to respond to a couple of points in your question (this is more a comment than an answer, but since SO is stupidly limited in this, I'll put it here instead.)

that uses web standards css (instead of tables),

There is no "css instead of tables" - they are two distinct and compatible things!

CSS describes visual aspects of a document, whilst tables markup tabular data.

If you're displaying tabular data, then tables is exactly what you should be using, and you can use CSS to make it look more exciting than the plain styles that tables come in.

Since you're asking for a CRUD app, odds are you are going to be wanting to display tabular data so should be using tables.

(The common mistake people make is not understanding the nature of the web, and using tables to apply grid layouts to documents, when they should be using strucuted semantic markup instead.)

that uses best practices (CF9 has changed so many things now: scripted components, ORM)

Scripted components are not a best practise!

They are an alternative syntax (for people that prefer having non-descriptive braces everywhere) they do not offer anything you can't already do.

Answer 2

i would strongly suggest you check out cfwheels. read the documentation, it's built for doing such crud applications and has an amazing set of features and will save you a lot of time. as for the interface, there are many jquery plugins out there that can handle this. i suggest looking at ajaxrain and find a plugin you like