Looks like you have an update trigger on the update.
"This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Scott Mulholland <[EMAIL PROTECTED]> To: CF-Talk <[email protected]> Sent: Wed Jul 26 20:29:47 2006 Subject: RE: Odd Query issue Yeah, its ms-sql, and yes, does seem silly that I hadn't done that yet ;) Query analyzer gave me the same result for the update but with a better error message, "Invalid column job_id, Procedure jobs_UTrig". Looks like it's an issue with one of my relationships/constraints. Thanks, Scott -----Original Message----- From: Brian Rinaldi [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 1:34 PM To: CF-Talk Subject: Re: Odd Query issue This may seem silly but did you pop this into query analyzer (assuming this is MS SQL...I didn't see you mention what database it is). I have found that when you get odd errors like this back from a query sometimes they are misreporting the error...if you try it in query analyzer you may get a clearer error message. My guess is the problem lies in the word satus and not in job_id...so try bracketing that keyword (which btw using Query Analyzer will highlight potential keyword conflicts for you too). Hope that helps. - Brian Rinaldi blog - http://www.remotesynthesis.com/blog CF Open Source List - http://www.remotesynthesis.com/cfopensourcelist Boston CFUG - http://www.bostoncfug.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247810 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
