FAQ

How to convert all special chars with underscore(any other chars)?

Sometime special chars create issue for reading or writing any file or string. Most probably all browser not cause issue with underscore(_). Look below string to convert special chars to underscore(_).
<cfset filename = rereplacenocase(filename,"[\W]","_","all") />

How to use Multiple Statements for MySQL 4/5 Datasource In ColdFusion 8?

You just need to enter allowMultiQueries=true in connection string.