PreserveSingleQuote Gotcha
#preservesinglequotes(myArray[1])#
was returning the error. Invalid CFML construct found on line 8 at column 26.ColdFusion was looking at the following text:
[I was sure that the array held a query then have just found out that preserveSingleQuotes only excepts simple values. So the above code should look more like
#preservesinglequotes(sqlQry)#
You would think that surely this could be error trapped by the CF server to inform you that you can only pass in simple values?