Hi,
I've got a problem with the following function, which seems to have
been caused by upgrading to CFMX7 - it is now only returning an empty
query with a single "COL_NAMES" column, rather than a proper set of
data.
The "theQuery" variable is the result of an Ingres stored procedure.
The purpose of the function being to turn the results columns from
that procedure into CF-compatible names.
I'm hoping that someone here can either provide a fix for the
function, or point out an alternative method (that obviously results
in the same output).
Here's the function:
~~~
<cfscript>
//Map columns UDF...
function mapColumns(theQuery) {
//Declare local vars
var realColumnList = "";
var columnNamesList = "";
var columnNamesArray = "";
//Get the real column names based on the first row/column of
result set...
realColumnList = theQuery["RESULT ELEMENT0"][1];
//Prepend a dummy column name for the first column
realColumnList = listPrepend(realColumnList,"COL_NAMES");
//Create a String object with our new column names...
columnNamesList = createObject("java","java.lang.String");
columnNamesList.init(realColumnList.toString());
//Convert to a String Array!
columnNamesArray = columnNamesList.split(",");
//Change the column names of the result set using the array!
theQuery.setColumnNames(columnNamesArray);
return true;
}
</cfscript>
~~~
Thanks for any help.
Peter
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205386
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
