Raymond Camden's Blog Rss

Get Cooking with ColdFusion...

18

Posted in ColdFusion | Posted on 01-06-2006 | 3,113 views

So, I warned you - and now it's here. I'm happy to announce the (Beta) launch of the ColdFusion Cookbook. The site is mostly feature complete. We even have content! Thanks to Rob Brooks-Bilson and Jeremy Petersen. They have graciously donated content and given the site a great start.

Some points:

  • The comments engine isn't ready. It's almost ready. I should have that up in a day or two.
  • The PDF is ugly. Butt Ugly. Please help me. Any comments (or even code) would be greatly appreciated. Also - it is generated on demand. I already have a plan in mind on how to correct that. (And I'll blog it, since I think it is a good idea.)
  • Any other comments would be welcome as well.

Comments

[Add Comment] [Subscribe to Comments]

Jeremy Petersen said on 01-06-2006 at 10:13 PM #
Thank you for all of your efforts Ray.

Unless we have O'Reilly complications, should have a bunch more content to post over these next couple of weeks.
James Holmes said on 01-07-2006 at 12:44 AM #
I've already started adding content for the security section, for you to bash around as you see fit. This is one of my favourite subjects (along with CFAJAX) so I'm happy to contribute.
Joe Rinehart said on 01-07-2006 at 7:29 AM #
Hey Ray,

That was quick! Could we maybe add a "Database / SQL" category? I've got some content I'd like to add, and there's no place for it :(

Cheers,

Joe
Dave Carabetta said on 01-07-2006 at 11:33 AM #
Hey Ray. Nice work. On the main page "effecient" should be spelled "efficient" though. Sorry, I'm picky like that.
Raymond Camden said on 01-07-2006 at 12:17 PM #
Done. Anyone know of a spell checker for Eclipse?
Raymond Camden said on 01-07-2006 at 12:23 PM #
I will add one. I should have made it clear folks can submit stuff in categories that don't exist.
maxx said on 01-07-2006 at 6:29 PM #
FYI: the rss feed seems to be missing the /entry/ folder.
Raymond Camden said on 01-07-2006 at 7:14 PM #
Maxx - thanks. Fixed.
Scott said on 01-08-2006 at 12:12 AM #
Ray, what about adding the number of articles to the description page?

Example:
Data Structures (7)
Database/Sql (10)
tof said on 01-08-2006 at 1:12 AM #
Hey pardon my french (well I am french after all ;-)) but...
Nice Fu__ing Work!
Nathan Drury said on 01-09-2006 at 12:19 AM #
Hi Ray

Thanks for the CF Cookbook - great idea! I'm using it already, which is how I found an error with the "How do I mail the contents of a form?" recipe - wrap="80" should be wraptext="80".

Keep up the good work!
Raymond Camden said on 01-09-2006 at 5:16 AM #
Oops - thanks Nathan. It is fixed.
Raymond Camden said on 01-09-2006 at 8:22 AM #
Scott - time to reveal my ignorance. Assume table A has a join table with B called A_B. That is how I assign entries to categories. What SQL would I use to select * from A and get the _count_ from A_B where A_B.aid = A? I'm such a SQL noob.
brian buck said on 01-09-2006 at 9:22 AM #
what DB? this should work in MSSQL Server.

SELECT A.*, (SELECT COUNT(AID) FROM A_B WHERE A_B = A) AS ABCOUNT<br>
FROM A;
Raymond Camden said on 01-09-2006 at 1:01 PM #
Brian - done.
Joe Rinehart said on 01-09-2006 at 1:18 PM #
Ray,

If you're using a DAO/Bean implementation, I've shifted some things, like counting articles in a category, to being a property of the Category bean that's maintained through persistence and business logic, so that I don't have to do the (not very, admittedly) costly nested SELECT statement.

Basically that's a lot of words to say that I sometime just put an ArticleCount columng in the Category table, and maintain that property as necessary (possibly directly in ArticleDAO, or by having ArticleDAO use a CategoryDAO to get the category, change it, and commit it...whatever's necessary).
Raymond Camden said on 01-09-2006 at 1:27 PM #
Joe - am I reading you right? Are you saying that when you update an article you then update a count column in the db? Why would that be "DAO/Bean"? I mean - I can see the speed benefit for the client - but I don't see why it would be more DAO/Bean-ish. ;) I simply updated getCategories in the categoryGateway.cfc.
Scott said on 01-09-2006 at 4:45 PM #
Ray - thanks for doing this.

Brian - thanks for answering ray's question.

[Add Comment] [Subscribe to Comments]