Hey not a problem. Thanks for the help. I still have not solved the problem. Like I said, it is driving me crazy. Nick
>> >> On 1/23/08, Brian Kotek <[EMAIL PROTECTED] > wrote: >> > Yes this is the real problem. You're referencing the table by the wrong >> name >> > in the where clause. >> >> good catch Brian. We're like home inspects.. find one bug and point >> it out and we've done our job =) > > >I'd just like to point out that I spotted that and posted it as a response >before any other replies to the OP had been posted (or had got to me). But >then, there were a shed load of others that got in the way ;) > >And yes, I am a tart for pointing that out. > >Dominic ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297230 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

