Neat, it fails to rename the field that is from the last joined table... (and again, this didn't occur in oracle)...
so if I change the order of the join statement so C is joined first and then B, then ERUSERFLAG comes through, while SECURITY_GROUP remains "TBLFLD". This should be fun to talk to Macromedia about! - Rick Rick Root wrote: > Well, I installed the cf7 trial on my test server, and started running > some initial tests. > > Damn me for having to use DB2 on a mainframe, but the following query > doesn't work, and it fails in an inconsistent manner: > > <CFQUERY NAME="qry" DATASOURCE="DSNa" DEBUG maxrows="1"> > SELECT > A.USERID, > B.TABLFLD AS SECURITY_GROUP, > C.TABLFLD AS ERUSERFLAG > FROM > (ADUADS01.WEBALLUSERS A LEFT JOIN ADUADS01.TMOTB905 B > ON A.userid=B.TABLKEY AND B.TABLID='940' AND B.FLDSEQ=2) > LEFT JOIN ADUADS01.TMOTB905 C > ON A.userid=C.TABLKEY AND C.TABLID='940' AND C.FLDSEQ=19 > </CFQUERY> > <cfdump var="#qry.columnlist#"> > > > outputs: > > SECURITY_GROUP,TABLFLD,USERID > > Note that C.TABLFLD is not properly renamed to ERUSERFLAG. > > I'm willing to bet this is another one of those DB2 mainframe thing. > > I just verified that the exact same query works fine when the underlying > database is Oracle. > > Sigh. > > - Rick > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193445 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
