CFLib.org – AccessPatternMatchingFormat

AccessPatternMatchingFormat(string)

Last updated August 14, 2002

author

Version: 2 | Requires: ColdFusion 5 | Library: StrLib

Rated 0 time(s). Average Rating: 0

Description:
A visitor may enter wildcard characters into a search string without realising. An invalid search string can then produce either a database error or odd results. This is a particular problem with double-byte languages like Japanese where a [ for example may be hidden inside a character.

Return Values:
Returns a string.

Example:

view plain print about

<cfoutput>
"98.3%" becomes "#AccessPatternMatchingFormat("98.3%")#"
</cfoutput>

<cfoutput>
"98.3%" becomes "#AccessPatternMatchingFormat("98.3%")#"
</cfoutput>

Parameters:

Name	Description	Required
string	The string to format.	Yes

Full UDF Source:

	
	
			
			
			
				
				view plain
				
				
				copy to clipboard
				
				
				
				
				print
				
				
				about
				ColdFISH is developed by Jason Delmore.  Source code and license information available at coldfish.riaforge.org.  Version 3.1.1
				
			<cfscript>
/**
 * Strip pattern-matching wildcards from a string appearing in an Access query.
 * Modded list order (rkc 8/14/02)
 * 
 * @param string 	 The string to format. (Required)
 * @return Returns a string. 
 * @author Matthew Walker (&#109;&#97;&#116;&#116;&#104;&#101;&#119;&#64;&#99;&#97;&#98;&#98;&#97;&#103;&#101;&#116;&#114;&#101;&#101;&#46;&#99;&#111;&#46;&#110;&#122;) 
 * @version 2, August 14, 2002 
 */
function AccessPatternMatchingFormat(string) {
	return ReplaceList(string, "[,%,_,##", "[[],[%],[_],[##]");
}
</cfscript>
		<cfscript>
/**
 * Strip pattern-matching wildcards from a string appearing in an Access query.
 * Modded list order (rkc 8/14/02)
 * 
 * @param string      The string to format. (Required)
 * @return Returns a string. 
 * @author Matthew Walker (matthew@cabbagetree.co.nz) 
 * @version 2, August 14, 2002 
 */
function AccessPatternMatchingFormat(string) {
    return ReplaceList(string, "[,%,_,##", "[[],[%],[_],[##]");
}
</cfscript>