Use the following example to copy and paste your own debugging code in - highlight everything in blue, like the example below. At the very least, select the entire query with parameters. Only copy one query at a time, please.
SQL Queries
qryName (Datasource=dopefly, Time=1176ms, Records=10) in D:\scribble.cfm @ 19:06:53.053
select top 10 * from comments where Name = ? or Name = ? and subscribe = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = MrNate
Parameter #2(cf_sql_varchar) = Nathan Strutz
Parameter #3(cf_sql_integer) = 0