That is just how MX displays the SQL in error messages, when you actually insert Data it goes in as it should. Not completely sure why it displays it like that though.
Ben -----Original Message----- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 4:22 PM To: CF-Talk Subject: CFQUERY replacing ' with &apos I'm seeing this at my error of my cfquery... I cold fusion changing th query or is it the wasy CF outputs the error. I'm tryiing to update a timestamp and and a Hash. My output UPDATE Users SET DateHired = '{ts '2002-10-02 00:00:00'}, Username = 'bob', Password = '3E10345509ECC8C64CB963034131A7DA' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
