CF regex question [SOT]

2010-05-28 Thread Greg Morphis
I just ran into a problem with some old code one of team mates did. He used cfqueryparams but did not specify a cfsqltype. We upgraded our DB from Oracle 9i to 10g and all of the sudden we're getting Error Executing Database Query errors. Logs show A nonnumeric character was found when expecting

RE: CF regex question [SOT]

2010-05-28 Thread Andy Matthews
three match. andy -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Friday, May 28, 2010 1:39 PM To: cf-talk Subject: CF regex question [SOT] I just ran into a problem with some old code one of team mates did. He used cfqueryparams but did not specify a cfsqltype

Re: RE: CF regex question [SOT]

2010-05-28 Thread Greg Morphis
Seems to work beautifully! Thanks! On May 28, 2010 3:05 PM, Andy Matthews li...@commadelimited.com wrote: Per the good Jason Dean at www.12robots.com: cfqueryparam(.?[^(cf_sql_type)])+? Tested against these: cfqueryparam value=foo / cfqueryparam value=foo cfqueryparam value=#foo#

Re: CF regex question [SOT]

2010-05-28 Thread Will Tomlinson
Seems to work beautifully! Thanks! As long as you don't have any variables/values with cf in them. hehehe.. cfqueryparam value=anythingcfanything / doesn't match. ~| Order the Adobe Coldfusion Anthology now!