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