Today, I happened to be a serious mistake in the use of query or query. I lost half an hour to figure out where the problem was.
A simple query of query like this:
select field1 from TBL_MASTER WHERE field2 like ' #myVar#'
After a half hour test I found that the problem was in the myVar variable that was always compared in a "case sensitive". I had never noticed this detail.
Someone can give me more information?
The system is Win Coldfusion 8 with MS Sql Server 2008