Get Cooking with ColdFusion...
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
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.
# Posted By James Holmes
| 1/7/06 12:44 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
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
# Posted By Joe Rinehart
| 1/7/06 7:29 AM
Hey Ray. Nice work. On the main page "effecient" should be spelled "efficient" though. Sorry, I'm picky like that.
# Posted By Dave Carabetta
| 1/7/06 11:33 AM
Done. Anyone know of a spell checker for Eclipse?
# Posted By Raymond Camden
| 1/7/06 12:17 PM
I will add one. I should have made it clear folks can submit stuff in categories that don't exist.
# Posted By Raymond Camden
| 1/7/06 12:23 PM
FYI: the rss feed seems to be missing the /entry/ folder.
# Posted By maxx
| 1/7/06 6:29 PM
Maxx - thanks. Fixed.
# Posted By Raymond Camden
| 1/7/06 7:14 PM
Ray, what about adding the number of articles to the description page?
Example:
Data Structures (7)
Database/Sql (10)
Example:
Data Structures (7)
Database/Sql (10)
# Posted By Scott
| 1/8/06 12:12 AM
Hey pardon my french (well I am french after all ;-)) but...
Nice Fu__ing Work!
Nice Fu__ing Work!
# Posted By tof
| 1/8/06 1:12 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!
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!
# Posted By Nathan Drury
| 1/9/06 12:19 AM
Oops - thanks Nathan. It is fixed.
# Posted By Raymond Camden
| 1/9/06 5:16 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.
# Posted By Raymond Camden
| 1/9/06 8: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;
SELECT A.*, (SELECT COUNT(AID) FROM A_B WHERE A_B = A) AS ABCOUNT<br>
FROM A;
# Posted By brian buck
| 1/9/06 9:22 AM
Brian - done.
# Posted By Raymond Camden
| 1/9/06 1:01 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).
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).
# Posted By Joe Rinehart
| 1/9/06 1:18 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.
# Posted By Raymond Camden
| 1/9/06 1:27 PM
Ray - thanks for doing this.
Brian - thanks for answering ray's question.
Brian - thanks for answering ray's question.
# Posted By Scott
| 1/9/06 4:45 PM
Unless we have O'Reilly complications, should have a bunch more content to post over these next couple of weeks.