Well obviously you wouldn't be using a column that you were trying to update. ----- Original Message ----- From: Jared Stark To: CF-Talk Sent: Friday, May 03, 2002 6:25 PM Subject: RE: Query Issue.
Except then if you try to update that same column later in the same query SQL Server will get upset with you. -----Original Message----- From: Kreig Zimmerman [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 4:23 PM To: CF-Talk Subject: Re: Query Issue. what i usually do is "columnname = columnname" which updates the content of the column, with the contents of the column--no problems there, eh? ----- Original Message ----- From: Jared Stark To: CF-Talk Sent: Friday, May 03, 2002 5:52 PM Subject: RE: Query Issue. I tried the 0 = 0 trick and SQL Server gives me an error. Does that work for you? ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
