Problem: A Coldfusion CFC has not been modified since 2006.
It has been working correctly till the present. We just migrated to
CF 8.0. Since migration, none of the INSERTs work. All of the
INSERTs in the CFC follow the following format:
INSERT INTO table1
(a,b,c)
SELECT a, b, c
FROM table1
WHERE a = x
AND b = y
AND c = z
Error:
Error Executing Database Query.
ORA-00933: SQL command not properly ended
The error occurred in
\\sw\regionweb\Dev\LB-IDS\C130\apps\ssl\ftims\TIS\tis.cfc: line 713
Called from
\\sw\regionweb\Dev\LB-IDS\C130\apps\ssl\ftims\TIS\reviseTIS.cfm:
line 3
711 : AND sub_system_index = #this.sub_system_index#
712 : AND test_sub_category = #this.test_sub_category#
713 : AND rev_number = '#this.rev_number#'
714 : </cfquery>
715 :
SQLSTATE 42000
SQL:
INSERT INTO ftim_tis_stakeholders
(project_number,
system_index,
sub_system_index,
test_sub_category,
rev_number,
rev_date,
tis_status,
originator,
modified_date)
SELECT #arguments.trgproject# project_number,
#arguments.trgsi# system_index,
#arguments.trgsub# sub_system_index,
#arguments.trgtsc# test_sub_category,
'new' rev_number,
'#dateformat(now())#' rev_date,
'd' tis_status,
#this.people_id# originator,
'#dateformat(now())#' modified_date
FROM ftim_assigned_tis_numbers
WHERE project_number = #this.project_number#
AND system_index = #this.system_index#
AND sub_system_index = #this.sub_system_index#
AND test_sub_category = #this.test_sub_category#
AND rev_number = '#this.rev_number#'
--------------------
If I stub out the offending INSERT call, the error jumps to
the next (and the next) subsequent INSERT call, pointing to that
WHERE clause as the error.
Is anyone else having similar problems upon migration? Does
CF8 not support INSERT-SELECTs? Is there another construct within
the code that has changed re CF8 and could cause this error? CF8
bug? I'm stumped!
Thanks, in advance, for any insight/solution.
1
Reply
AdChoices