Leigh, you were right! That's what it was but the problem only reared it's ugly head with Access with Unicode.. Since I can't reinstall CF on our prod box your solution saved me from having to replicate the DB in Oracle and then alter the queries to match. This app may not even be used much more so unless I absolutely had to, I didn't want to rewrite it.
I appreciate it! On Sat, Nov 12, 2011 at 9:59 AM, <> wrote: > > >>line 53* > > Do not take the line number as a hint. > When there is an error in a query, the error is returned by the driver and > CF doesn't know which line caused the error. > It will indicate any line in the query. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
