> I have never found that CFQUERY returns the columns in the order that I > specified them in. I can't be sure exactly what order though - probably > alphabetic. I have always had to store a separate list of columns to > ensure I can process them in the correct order. Mind you, I never used a > CFQUERY in the CFX interfaces (Java or C++).
Maybe I should of made it a bit clearer with point 1. When accessing the cfx java query interface pre mx the method getColumns() returned a string array, String[], containing the column names. The columns were ordered correctly in this string array - meaning the same order as the select statement. If an * was used (ie select *) the columns would be ordered based on the order in the table or view or whatever you were selecting from. I wrote a tag called cfx_columnList that returned the columns in correct order pre mx. That tag does not work correctly after mx. When using the same method, getColumns(), it now returns the String[] with the columns ordered alphabetically. I would of imagined the same method in the query interface would work the same way in both versions - it does not appear to be so. I have tested the same code in both versions with different results. I used 4.52 Enterprise and 6.1 to test with. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
