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?
No idea. Sounds very strange. Can you reproduce it? I've never seen that behavior. 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.

