> No idea. Sounds very strange. Can you reproduce it? I've never seen > that behavior.
Yes.. it was strange.. i havent been able to reproduce the error either. If i get it again.. sure will save the debug code. Joe > -----Original Message----- > From: Sean A Corfield [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 13, 2002 5:01 PM > To: CF-Talk > Subject: Re: Problem with single quotes(CFMX) > > > On Friday, Dec 13, 2002, at 11:26 US/Pacific, Joe Eugene wrote: > > select * from TableName where myField=apos;BMWapos; > > > > it was replacing "'" with string "apos;" . I tried a few > > things(preserve, > > build string.. and some others). None of them worked. I finally > > restarted the > > CFMX service.. and the query started working again. Strange... Any > > idea.. how > > this might happen? > > > Sean A Corfield -- Director, Architecture > Web Technology Group -- Macromedia, Inc. > tel: (415) 252-2287 -- cell: (415) 717-8473 > aim: seancorfield -- http://www.macromedia.com > An Architect's View -- http://www.corfield.org/blog/ > > Introducing Macromedia Contribute. Web publishing for everyone. > Learn more at http://www.macromedia.com/contribute > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm

