coldfusionJedi

This entry was posted on Friday, January 6, 2006 at 9:29 PM. It was filed in the following categories: ColdFusion. It has been viewed 2,417 times and has 18 comments.

TweetBacks

Comments

[Add Comment] [Subscribe to Comments]

• Comment 1 written by Jeremy Petersen on 6 January 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.

• Comment 2 written by James Holmes on 7 January 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.

• Comment 3 written by Joe Rinehart on 7 January 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

• Comment 4 written by Dave Carabetta on 7 January 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.

• Comment 5 written by Raymond Camden on 7 January 2006, at 12:17 PM

  

  Done. Anyone know of a spell checker for Eclipse?

• Comment 6 written by Raymond Camden on 7 January 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.

• Comment 7 written by maxx on 7 January 2006, at 6:29 PM

  

  FYI: the rss feed seems to be missing the /entry/ folder.

• Comment 8 written by Raymond Camden on 7 January 2006, at 7:14 PM

  

  Maxx - thanks. Fixed.

• Comment 9 written by Scott on 8 January 2006, at 12:12 AM

  

  Ray, what about adding the number of articles to the description page?
  
  Example:
  Data Structures (7)
  Database/Sql (10)

• Comment 10 written by tof on 8 January 2006, at 1:12 AM

  

  Hey pardon my french (well I am french after all ;-)) but...
  Nice Fu__ing Work!

• Comment 11 written by Nathan Drury on 9 January 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!

• Comment 12 written by Raymond Camden on 9 January 2006, at 5:16 AM

  

  Oops - thanks Nathan. It is fixed.

• Comment 13 written by Raymond Camden on 9 January 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.

• Comment 14 written by brian buck on 9 January 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;

• Comment 15 written by Raymond Camden on 9 January 2006, at 1:01 PM

  

  Brian - done.

• Comment 16 written by Joe Rinehart on 9 January 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).

• Comment 17 written by Raymond Camden on 9 January 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.

• Comment 18 written by Scott on 9 January 2006, at 4:45 PM

  

  Ray - thanks for doing this.
  
  Brian - thanks for answering ray's question.

[Add Comment] [Subscribe to Comments]