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
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
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#
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!
4 matches
Mail list logo