[thelist] ColdFusion/SQL - treat as Number

[Seth Bienek]

> Cold Fusion automatically escapes variables within cfquery

While this is technically true, I've found it to be inconsistent in it's application.  If you use a function for the value that contains the s-quote, for example, or like Joshua mentioned, if the value comes from a struction, the autoescape function breaks.  What else makes it break?  I dunno.. I usually run a regular expression on textarea fields for validation anyway.. 

There are exceptions to every rule of course, but when in doubt, I say play it safe.

What's that cfquery look like, Jon?

Regards,

Seth

------------------------------
Seth Bienek
Solutions Development Manager
Stonebridge Technologies, Inc.
972.455.7294 tel
972.404.9754 fax
ICQ #7673959
------------------------------