Writing international characters to oracle in CF5

[djprice]

When I try to write data to oracle with internaltional characters in it, it
will give the following error: Oracle Error Code = 1756 ORA-01756: quoted
string not properly terminated SQL = 'SELECT ProjectID, Project, Carline,
LeaderID, MemberID, LeadCert, MemCert, CoachID, Location, PMasterID,
RMasterID,PRTS, Approved1Date, CompleteDate, Approved2, Approved2Date,
Approved3Date, Approved4Date, cc_date, SubmitProj, SubmitProjFirst,
Approved3First, Metric, Savings, CurrentStatus, Projects.SubID,
JDP_Sub.SubCategory, JDP_Cat.Category FROM Projects, JDP_Cat, JDP_Sub WHERE
JDP_Cat.CatID = JDP_Sub.CatID AND JDP_Sub.SubID = Projects.SubID AND
CurrentStatus <> 'CNA' AND openClose <> 'Close' AND
Location=preservesinglequotes('GMB Gravata? ORDER by Project ASC' The last
filed is not completed because of the special character the appears as a box. I
have included the NLS_LANG attribute in the CF start up script to get the form
to be able to display these characters, but now they cannot be written to
oracle. This application was recently moved from windows CF5 to UNIX CF5. The
app worked OK in Windows. Please help.

[jonwrob]

Typically, that error occurs when you have a quote in the text you are trying
to insert. You didn't include the SQL for the insert. Are you using bind
variables? That usually takes care of that problem. If not, look up
cfprocparam in the docs.

JR