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:247808 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
