Oh boy is my face red ;-) This is what happens when you've worked weeks of 12-16 hour days ;-)
What I thought was happening was not! I had a test script to run a function (which contained this query). I hardcoded the values of the args I was passing in. I incorrectly passed in 5601 when the proper value was 5061. I confirmed I was passing the correct info by looking at the debugging info (forgetting that I was the bozo passing in the value....it wasn't being looked up as it would be in normal operations). So when I would run the query in TOAD I put the correct value in and the query ran.....in the other place where the same query was running correctly...it was looking up the ID correctly. Well....at least I can sleep tonight ;-) Thanks all Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273129 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
