CFQUERY Datatypes and Quotes


In CFQUERY operations, can someone advise as to the following:

  1. What data types REQUIRE single quotes for UPDATE and INSERT statements?
  • We are using MS SQL 2008 R2 with CF9
  1. Is it best practice to use CFQUERYPARAM for EVERY statement now days?

I searched everywhere but can’t seem to find any type of reference sheet anywhere that I can use when building my statemnts.

Thanks in advance.


The answer is simple! Don’t use single or double quotes, just use <CFQUERYPARAM>. Always :slight_smile: