Use the following example to copy and paste your own debugging code in. At the very least, select the entire query with parameters. Only one at a time, please.
SQL Queries
queryName (Datasource=dopefly, Time=1176ms, Records=10) in D:\Projects\TestProject\scribble.cfm @ 19:06:53.053
select top 10 * from blogComments 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
queryName (Datasource=dopefly, Time=1176ms, Records=10) in D:\Projects\TestProject\scribble.cfm @ 19:06:53.053
select top 10 * from blogComments 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