Question

76

rated 0 times [ 77] [ 1] / answers: 1 / hits: 28352 / 14 Years ago, tue, september 28, 2010, 12:00:00

I want to remove all special characters (,/{}etc.) from an input field being saved as a string to the DB.

What is the best approach?

Should this check be tackled with JS, ColdFusion or Microsoft SQL - Maybe all three?

How would I go about coding this using ColdFusion or Microsoft SQL?

Only authorized users can answer the question. Please sign in first, or register a free account.

Total Points: 318

Total Questions: 97

Total Answers: 119

Location: Turks and Caicos Islands

Member since Sun, Mar 7, 2021

3 Years ago

answered 14 Years ago stacie · Accepted Answer

You mean everything not alphanumeric?

I'd probably use a REReplace in the data layer.

<cfqueryparam 

  cfsqltype=cf_sql_varchar 

  value=#REReplace(myVar,[^0-9A-Za-z ],,all)# 

/>

Update: changed to include space.