Problem inserting data into field

[makweatan]

hI GUYS...

seems that I cant insert data into table.

I got this error:

DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: REASON;ECT = ?, STATUS = ?;,


here's the codes.

<script language="javascript">
//suzie added
$(document).ready(function(){
    $("#dialog").dialog({
        "modal": true,
        "autoOpen": false,
        "buttons": {
        "Hantar":function(){
    var f = document.getElementById('xcForm');
    f.action="xc18TolakAction.do";
    f.submit();
        },
    "Cancel": function() {
        $(this).dialog('close');
                }
            }
        });
});
 
function performRemsTolak(ele)
{
    $("#dialog").dialog('open');
 
}
 
<html:button styleClass="button" property="sbmit1" onclick="javascript:performRemsTolak(this)"><bean:message key="grq_XC18_TOLAK"/></html:button>
<div id="dialog" title="Reason "> : <input type="text"
name="xcForm" id="reason"                class="text ui-widget-content ui-corner-all" size="7" />
 
//in DAO.java
 
String status = xcbo.getStatus();
String reason = xcbo.getReason();
 
 
if ( status.equals(DCMSConstants.USERTODO_STATUS_SEDIA)
                || status.equals(DCMSConstants.USERTODO_STATUS_PREPARE))
        {
    update_field = new StringBuffer()
    .append(" OFFICER_PREPARE = ?, ")
    .append(" DATE_PREPARE = ?, ")
    .append(" STATUS = ? ")
    .append(" REASON = ?")
        .toString();
else if( status.equals(DCMSConstants.USERTODO_STATUS_TOLAK))
        {
 
    update_field = new StringBuffer()
        .append(" OFFICER_REJECT = ?, ")
        .append(" DATE_REJECT = ?, ")
        .append(" STATUS = ? ")
        .append(" REASON = ? ")
        .toString();
        }
 
PreparedStatement stmt = null;
        StringBuffer sql = new StringBuffer();
        sql.append(" UPDATE " + tableName + " SET ");
        sql.append(update_field);
        sql.append(" WHERE ");
        sql.append(" TAXPAYER_KEY = ?");
        sql.append(" AND FILE_NO = ?");
        sql.append(" AND TAXTYPE_KEY = ?");
 
 
stmt = conn.prepareStatement(sql.toString());
        stmt.setString(1, session.getUserBo().getUser_id());
        stmt.setTimestamp(2, now());
        stmt.setString(3, status);
        stmt.setInt(4,taxpayer_key);
        stmt.setString(5, file_no);
        stmt.setInt(6, taxtype_key);
        stmt.setString(7, reason);
        stmt.executeUpdate();
 

Thank u very much.

[gits]

this doesn't seem to be a JavaScript issue ... the SQL-query fails so does the serverside script get the correct values during the submit?

kind regards

[makweatan]

@gits
Thanks Gits....that means I should change the query, right?

[gits]

have a look here ... it seems that there is a syntax error in your query?

[makweatan]

thanks again Gits..will try to figure out when I get back to office...