I expected more from you Dave. :) 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.
Anyway, as with all other bugs, I'll take it into account in the future. > >While the failure of the Unicode driver to conform to the behavior of other >drivers you used previously may well be a bug, the ambiguity within your own >code that brought this failure to your attention is also a bug. One of these >two bugs can be fixed by you, the other can't. > >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:261987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
