I have never used CFSTOREDPROC, so can't really comment on this. But, I'd check the Adobe CF docs on CFSTOREDPROC and check if anything has changed between CF8 and CF10.
SELECT case trim(to_char(SYSDATE, 'DAY')) WHEN 'MONDAY' then '1' else '2' end AS TodaysDate from dual
SELECT Count(other_id) AS NoRecFound FROM gl_dup_ids_ssns WHERE Trim(create_date) =
SELECT Count(other_id) AS NoRecFound FROM gl_dup_ids_ssns WHERE Trim(create_date) = CF codes to Stop the process and email admin
Surely, that cannot be the actual SQL, as it is obviously invalid.
I looked at the CF administrator application log and see a better error message: Error Executing Database Query. Executing stored procedures is not allowed Is there a setting in the administrator where I can enable and disable ColdFusion to use CFSTOREPROC? if there is, I can't find it. For BKBK:
That query is actually working because I can see it got run in the debug screen
I found the answer! In case someone out there also facing the same issue. In the administrator, Datasource Advance setting, go down and find: Allowed SQL where there are checkboxes for Select, Update,Delete,Insert and one of them is store procedure checkbox. My checkbox was not checked that's why ColdFusion can't call a store procedure. I Checked and saved it and I'm good to go.
Curious solution! Thanks, Mega_L, for sharing it with us.