At 08:56 AM 2/19/2006, I myself wrote: >I have it now where the only character >that does not get stripped is the forward slash "/". The error I get >is this one: > >[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC >Microsoft Access Driver] Syntax error (missing operator) in query >expression '/'.
On further testing, this is what is happening: the two characters included in the regex below, the forward slash "/" and the dot "." do not get stripped: #rereplace(FORM.GPA, '[^0-9/.]', '', 'all')# So my questions are: 1- Does the forward slash perform a specific function, so that it has to stay in the regex? 2- If the user enters a dot with no numbers, e.g., "na.", the letters get stripped (which is good) but the dot does not, and it creates an error similar to the one quoted above. Any way of detecting such instances of dots with no numbers? 3- The MM document at (http://livedocs.macromedia.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/regexp3.htm#1117230)says the carat at the beginning of the regex makes it match only characters that appear at the beginning of the string. But in my tests, alphanumeric characters in any position get stripped. Am I reading the MM document properly? Thanks, Roberto ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232841 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54