ok..... update [reports] set password = 'xxxx'
Message: Error Executing Database Query. Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near 'xxxx'. Native Error Code: 170 SQL State: HY000 same error? tony -----Original Message----- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:15 PM To: CF-Talk Subject: RE: shooting my server soon.... Don't know. One of the secrets of T-SQL I guess. ;-) > -----Original Message----- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 3 December 2002 4:06 p.m. > To: CF-Talk > Subject: RE: shooting my server soon.... > > > but why can i do it fine in select statements? > > tony > > -----Original Message----- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 9:59 PM > To: CF-Talk > Subject: RE: shooting my server soon.... > > > Reports is a reserved word. Wrap it in [] > http://aspfaq.com/show.asp?id=2080 > > > > > -----Original Message----- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 3:45 p.m. > > To: CF-Talk > > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
