Suddenly can't populate a field with CF INSERT

Question

I have an INSERT command in a CF script to add a record to a data table. There are four fields I am populating. Fields three and four are being populated with the same data. Here’s the code:

INSERT INTO tblPQMS_Requests

(

PQMSReq_By,

PQMSReq_Status,

PQMS_Proj,

ERP_PQMS_Proj

)

VALUES

(

'LibMgr',

'1',

'#htmlEditFormat(projectno)#',

'#htmlEditFormat(projectno)#'

)

You see my comment on the last line. I can’t get projectno into ERP_PQMS_Proj. In fact, I can’t get ANYTHING into the field named ERP_PQMS_Proj, even if I just try to stick a bit of text into this text field.

Furthermore, the procedure worked until a few days ago!

I have never experienced this "locked-field syndrome" before and have spent hours trying to figure out what is going on. Any ideas? Thanks!

BKBK · Answer

Two remarks.1) HtmlEditFormat has been deprecated. Assuming you have a recent version of ColdFusion, replace it with EncodeForHTML.2) Use parameter-binding (cfsqltype). If your query fails because of parameter type, then ColdFusion will likely tell you so.Try something like:sqlString="INSERT INTO tblPQMS_Requests ( PQMSReq_By, PQMSReq_Status, PQMS_Proj, ERP_PQMS_Proj )VALUES ( :PQMSReqBy, :PQMSReqStatus, :PQMSProj, :ERPPQMSProj )";// Bind the parameter typessqlParameters={PQMSReqBy={value='LibMgr', cfsqltype="varchar"},PQMSReqStatus={value='1', cfsqltype="varchar"},PQMSProj={value='#encodeForHTML(projectno)#' , cfsqltype="varchar"},ERPPQMSProj={value='#encodeForHTML(projectno)#' , cfsqltype="varchar"}}// insert-queryqueryExecute(sqlString, sqlParameters, {datasource="yourDSN"});

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded