Query of Query gotcha

  • Post author:
  • Post category:Uncategorized

This might be old news to many of you, but I learned something new about Query of Queries today. I was trying to track down a bug where some data was not being found by a QofQ. It turned out that the case sensitivity of the data didn’t match, and QofQ is case sensitive! I didn’t know that. Here was my query: select fullName from nameQuery where uid = '#trim(chAssignedTo)#'In that query, the data in “uid” was always upper case, but some of the data in chAssignedTo was lower case, so in those cases ColdFusion didn’t match the records. In other words, in a ColdFusion Query of Query “JAM5245” <> “jam5245”. I know this is not a bug, because some databases are case sensitive, and as far as I know that is ANSI SQL compliant. I just never new that QofQ was case sensitive. Learn something new every day. 🙂