That is pretty weird. We work on an Air Force system with CF MX 7 and a DB 2 z/OS mainframe DB.
We're using the type 4 drivers that ship with DB2 Connect and not seeing this problem. What driver are you using? > -----Original Message----- > From: Rick Root [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 27, 2006 10:44 AM > To: CF-Talk > Subject: DB2 mainframe queries still not working properly! =( > > I'm just going to vent to the list here for a second. > > This is a bug that I'vek now about for a while, and have reported to > adobe several times, but I haven't bothered to verify its existence in > Coldfusion 7 since we haven't beeing using hte DB2 JDBC drivers until > recently. > > Consider the following coldfusion code: > > <cfquery name="qry2" datasource="DSNa" maxrows="1"> > select TABLKEY AS USERID, TABLFLD AS FULLNAME > from ADUADS01.TMOTB905 > WHERE TABLKEY='ADSRJR' > </cfquery> > <cfdump var="#qry2#"> > <cfdump var="#getMetaData(qry2)#"> > > The column names returned by this query are "TABLKEY" and "TABLFLD" > > I'd love to call Adobe about this, but they apparently don't offer "per > incident" support. Nice. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:254377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
