Apparently ColdFusion automatically escapes quotes in SQL statements; however, there is a syntax issue, as I found out here.

In brief, you can not do calculations inside the cfquery tag. instead, create a temporary variable to hold the calculated values.

Related Scribbles:

ColdFusion Notes

---

ID: 470
Author:
leonard
Date Updated:
2004-05-18 17:11:15
Date Created:
2004-05-18 17:11:15

Edit

---

Comments?

 >> Leonard Chan's Homepage  >> Scribble Web  >> Escape quotes in Cold Fusion

leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.