At 10:04 PM 2/14/2006, Charlie Griefer wrote: > > - if there are only spaces, it throws an error; > > - if there is text (e.g., "n/a"), it throws an error. > >"it" throws an error? what is "it"? the regex? the query? what >is the error?
I've done more testing, and 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 '/'. I'm using the strip code right before my UPDATE to put the resulting value in a variable: <cfset GPA = #rereplace(FORM.GPA, '[^0-9/.]', '', 'all')#> Any idea on how to modified the code so that forward slashes are also stripped? Thanks, Roberto Perez ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232839 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