Answered
Update Error
I can't see my error in this code to save my life.
The error I'm getting is:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
I'm using an Access database since the application is on a special server w/ no other types of database available. I'm sure I'm must missing something simple that I can't see after looking at it for so long. Such a basic thing yet I'm totally blanking on it.
This is the code:
<cfquery name="get_info" datasource="#application.ds#">
Update CCD
SET CCD_NAME = '#CCD_NAME#',
STATUS = '#STATUS#',
OP_CONT = '#OP_CONT#',
JRAC_ASSIGNED = '#JRAC_ASSIGNED#',
REQUEST_DAY = '#REQUEST_DAY#',
NEED_DAY = '#NEED_DAY#',
CCD_DESCRIPTION = '#CCD_DESCRIPTION#',
SYSTEMS_AFFECTED = '#SYSTEMS_AFFECTED#',
PROGRAM_ELEMENT = '#PROGRAM_ELEMENT#',
F_3600_FY05 = #F_3600_FY05#,
F_3010_FY05 = #F_3010_FY05#,
F_3011_FY05 = #F_3011_FY05#,
F_3020_FY05 = #F_3020_FY05#,
F_3080_FY05 = #F_3080_FY05#,
F_3400_FY05 = #F_3400_FY05#,
F_OTHER_FY05 = #F_OTHER_FY05#,
F_3600_FY06 = #F_3600_FY06#,
F_3010_FY06 = #F_3010_FY06#,
F_3011_FY06 = #F_3011_FY06#,
F_3020_FY06 = #F_3020_FY06#,
F_3080_FY06 = #F_3080_FY06#,
F_3400_FY06 = #F_3400_FY06#,
F_OTHER_FY06 = #F_OTHER_FY06#,
F_3600_FY07 = #F_3600_FY07#,
F_3010_FY07 = #F_3010_FY07#,
F_3011_FY07 = #F_3011_FY07#,
F_3020_FY07 = #F_3020_FY07#,
F_3080_FY07 = #F_3080_FY07#,
F_3400_FY07 = #F_3400_FY07#,
F_OTHER_FY07 = #F_OTHER_FY07#,
FUNDED_YN = '#FUNDED_YN#',
FUNDED_YN_DAY = '#FUNDED_YN_DAY#',
NEW_START = '#NEW_START#',
NEW_START_INT = '#NEW_START_INT#',
NEW_START_COMPLETED = '#NEW_START_COMPLETED#',
REPROGRAMMING_YN = '#REPROGRAMMING_YN#',
REPROGRAMMING_INT = '#REPROGRAMMING_INT#',
REPROGRAMMING_COMPLETED = '#REPROGRAMMING_COMPLETED#',
CCD_DAY_RECEIVED = '#CCD_DAY_RECEIVED#',
CSAF_VALIDATION_DAY = '#CSAF_VALIDATION_DAY#',
CSAF_VALIDATION = '#CSAF_VALIDATION#',
RRAC_DAY = '#RRAC_DAY#',
RRAC_REC = '#RRAC_REC#',
RRPC_DAY = '#RRPC_DAY#',
RRPC_DECISION = '#RRPC_DECISION#',
PMD_ISSUED = '#PMD_ISSUED#',
PMD_ISSUED_DAY = '#PMD_ISSUED_DAY#',
DOC_URL_1 = '#DOC_URL_1#',
DOC_URL_2 = '#DOC_URL_2#',
DOC_URL_3 = '#DOC_URL_3#',
DOC_URL_4 = '#DOC_URL_4#',
DOC_URL_5 = '#DOC_URL_5#',
DOC_URL_6 = '#DOC_URL_6#',
DOC_URL_7 = '#DOC_URL_7#',
DOC_URL_8 = '#DOC_URL_8#',
DOC_URL_9 = '#DOC_URL_9#',
DOC_URL_10 = '#DOC_URL_10#'
WHERE CCD_TRACKING = '#URL.CCD_TRACKING#'
</cfquery>
The error I'm getting is:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
I'm using an Access database since the application is on a special server w/ no other types of database available. I'm sure I'm must missing something simple that I can't see after looking at it for so long. Such a basic thing yet I'm totally blanking on it.
This is the code:
<cfquery name="get_info" datasource="#application.ds#">
Update CCD
SET CCD_NAME = '#CCD_NAME#',
STATUS = '#STATUS#',
OP_CONT = '#OP_CONT#',
JRAC_ASSIGNED = '#JRAC_ASSIGNED#',
REQUEST_DAY = '#REQUEST_DAY#',
NEED_DAY = '#NEED_DAY#',
CCD_DESCRIPTION = '#CCD_DESCRIPTION#',
SYSTEMS_AFFECTED = '#SYSTEMS_AFFECTED#',
PROGRAM_ELEMENT = '#PROGRAM_ELEMENT#',
F_3600_FY05 = #F_3600_FY05#,
F_3010_FY05 = #F_3010_FY05#,
F_3011_FY05 = #F_3011_FY05#,
F_3020_FY05 = #F_3020_FY05#,
F_3080_FY05 = #F_3080_FY05#,
F_3400_FY05 = #F_3400_FY05#,
F_OTHER_FY05 = #F_OTHER_FY05#,
F_3600_FY06 = #F_3600_FY06#,
F_3010_FY06 = #F_3010_FY06#,
F_3011_FY06 = #F_3011_FY06#,
F_3020_FY06 = #F_3020_FY06#,
F_3080_FY06 = #F_3080_FY06#,
F_3400_FY06 = #F_3400_FY06#,
F_OTHER_FY06 = #F_OTHER_FY06#,
F_3600_FY07 = #F_3600_FY07#,
F_3010_FY07 = #F_3010_FY07#,
F_3011_FY07 = #F_3011_FY07#,
F_3020_FY07 = #F_3020_FY07#,
F_3080_FY07 = #F_3080_FY07#,
F_3400_FY07 = #F_3400_FY07#,
F_OTHER_FY07 = #F_OTHER_FY07#,
FUNDED_YN = '#FUNDED_YN#',
FUNDED_YN_DAY = '#FUNDED_YN_DAY#',
NEW_START = '#NEW_START#',
NEW_START_INT = '#NEW_START_INT#',
NEW_START_COMPLETED = '#NEW_START_COMPLETED#',
REPROGRAMMING_YN = '#REPROGRAMMING_YN#',
REPROGRAMMING_INT = '#REPROGRAMMING_INT#',
REPROGRAMMING_COMPLETED = '#REPROGRAMMING_COMPLETED#',
CCD_DAY_RECEIVED = '#CCD_DAY_RECEIVED#',
CSAF_VALIDATION_DAY = '#CSAF_VALIDATION_DAY#',
CSAF_VALIDATION = '#CSAF_VALIDATION#',
RRAC_DAY = '#RRAC_DAY#',
RRAC_REC = '#RRAC_REC#',
RRPC_DAY = '#RRPC_DAY#',
RRPC_DECISION = '#RRPC_DECISION#',
PMD_ISSUED = '#PMD_ISSUED#',
PMD_ISSUED_DAY = '#PMD_ISSUED_DAY#',
DOC_URL_1 = '#DOC_URL_1#',
DOC_URL_2 = '#DOC_URL_2#',
DOC_URL_3 = '#DOC_URL_3#',
DOC_URL_4 = '#DOC_URL_4#',
DOC_URL_5 = '#DOC_URL_5#',
DOC_URL_6 = '#DOC_URL_6#',
DOC_URL_7 = '#DOC_URL_7#',
DOC_URL_8 = '#DOC_URL_8#',
DOC_URL_9 = '#DOC_URL_9#',
DOC_URL_10 = '#DOC_URL_10#'
WHERE CCD_TRACKING = '#URL.CCD_TRACKING#'
</cfquery>
AdChoices