Message: Error Executing Database Query. Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near 'xxxx'. Native Error Code: 170 SQL State: HY000
i can change it to anything, the value that xxxx is right now, i can make that anything, and nothing works. its a varchar field, that i can do a select statement from, and get anything i want.... WTF TIA tony... -----Original Message----- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:48 PM To: CF-Talk Subject: Re: shooting my server soon.... What sort of error message are you receiving? ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 8:44 PM Subject: shooting my server soon.... > why? > > update reports set password = 'xxxx' > > will not work in my cf code on my cfmx server. > > i can run the same query in query analyzer, and all is well. > > any explanation would save my ***king server... > > thanks > > ...tony > > tony weeg > [EMAIL PROTECTED] > www.revolutionwebdesign.com > rEvOlUtIoN wEb DeSiGn > 410.334.6331 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

