> I expected more from you Dave. :) I'm sorry to disappoint. But as a consultant, it's my job to tell people the unpleasant things they don't want to hear. I'll be sending you a bill, of course. I'd type a smiley face here, but I'm too priggish to do that.
> It's an inner join that will always have the same value in > both columns or nothing will be returned. * is a standard > wildcard to call all columns in all tables. I see "experts" > write sql that way all the time. If it were a left join with > the possibility of different values, obviously I'd write my > SQL different. That doesn't excuse whoever released this > buggy driver making up the rules as they go. First, you need to seek a better class of experts. Anybody worthy of being called an expert web application developer would tell you to only select the columns that you need. Second, you should try to avoid any ambiguity in your code. I'm not trying to excuse anybody from anything - I don't have a horse in this race. But writing ambiguous commands in any programming environment is asking for trouble, and you shouldn't be surprised when you get what you ask for. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:261994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
