Dave Watts wrote: >> Well...it indicates that there wasn't an error. It doesn't >> actually indicate that anything was updated. UPDATE sometable >> SET somecolumn = 'somevalue' WHERE 1=0 won't throw an >> error...but it also doesn't do anything. > > If you run a query that filters out all rows, it would still be successful, > which is what the original poster asked.
Right, I just wanted to point out that the lack of an error does not mean that anything was updated. I know you understand this, but I'm just afraid that others who are new to SQL may take your statement at face value. I've run into cases where people were running updates on a table where the record they were attempting to update did not exist. No error, but also no update. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4