coldfusionJedi

This entry was posted on Thursday, July 2, 2009 at 3:38 PM. It was filed in the following categories: ColdFusion. It has been viewed 1,907 times and has 13 comments.

TweetBacks

Comments

[Add Comment] [Subscribe to Comments]

• Comment 1 written by Josh Curtiss on 2 July 2009, at 3:52 PM

  

  Whoah. What the heck is right.

• Comment 2 written by Mischa on 2 July 2009, at 4:13 PM

  

  I remember an IBM rep telling me once that the DB2 engine on their AS/400 was still getting updates and fixes regularly because "customers always seem to be able to write a query that throws an error". And that it one of the oldest SQL engines out there...

• Comment 3 written by Mischa on 2 July 2009, at 4:14 PM

  

  it=is

• Comment 4 written by Robert Gatti on 2 July 2009, at 4:15 PM

  

  Does q2 also get changed?

• Comment 5 written by Raymond Camden on 2 July 2009, at 4:18 PM

  

  Nope.

• Comment 6 written by goldCoastNerd on 2 July 2009, at 8:15 PM

  

  hah, if i had a doller for everytime Q of Q acted in a totally weird way, i'd be pretty rich by nw... i try not to use Q of Q unless i have to , prefer doing everything in SQL..

• Comment 7 written by DRew on 2 July 2009, at 9:12 PM

  

  ditto goldcoastNerd. The lack of documented syntax, no joins or aliasing, and speed has made me prefer to use complex db queries rather and qoq's.

• Comment 8 written by Joshua Curtiss on 2 July 2009, at 10:18 PM

  

  In general, I'd say it's better to write joins in a db query than doing q of q. ColdFusion's specialty isn't database processing. :-D But sometimes tables can't be joined or other scenarios exist (working with non-db data) where query of queries is so handy!

• Comment 9 written by Joshua Curtiss on 2 July 2009, at 10:19 PM

  

  In general, I'd say it's better to write joins in a db query than doing q of q. ColdFusion's specialty isn't database processing. :-D But sometimes tables can't be joined or other scenarios exist (working with non-db data) where query of queries is so handy!

• Comment 10 written by JC on 6 July 2009, at 4:40 PM

  

  In this case, the join was the result of a SQL query and a query object built on the fly using other data.

• Comment 11 written by Andy Sandefer on 7 July 2009, at 11:38 AM

  

  Not to sound too absolutest (that's probably not a real word ;)) but I have a general rule about when to use a query of query. If I'm going after table data in a database I flat out will avoid using query of query like the plague. However, it does have its place when you need to perform complex querying on queryable (again - not a real word! ;)) non-table data. Query of query can totally save you when you need to query data returned from a cfdirectory call or data that you've retrieved from an exchange server. Complex file handling and e-mail data is a good place to start using query of query - just some food for thought.

• Comment 12 written by Albert on 5 August 2009, at 8:40 AM

  

  I have another issue with QofQ.
  I am trying to use string functions in QofQ like LEFT(string, count), or RIGHT(string, count) and I have:
  " Query Of Queries syntax error.
  Encountered "Left. Incorrect Select List, Incorrect select column".
  For first query I am using a :
  <cfdirectory directory="#application.installPath##application.PDFfilesDir#" name="memberList" action="LIST" sort = "directory ASC">
  Then,
  <cfquery dbtype="query" name="reportsQuery">
  SELECT distinct Name, Left(Name, 12) AS PDF
  FROM memberList
  </cfquery>
  I need to show only first 12 charachters in the <cfselect>

• Comment 13 written by Raymond Camden on 5 August 2009, at 1:15 PM

  

  The simple answer is that it is not supported. Check the docs as it details which functions are supported in QoQ.

[Add Comment] [Subscribe to Comments]