How to get size of field from metadata?

I am trying to get the size of a field from a getMetaData call...
If you dump getMetaData, it says it has a method called
getColumnDisplaySize...

here is what I am doing...

gettable is a cfquery... a simple "select * from tablename"
where tablename is a table in my Oracle database....

<cfset md = gettable.getMetaData()>
<cfset fieldsize = 0>
<cfset numCols = md.getColumnCount()>
<!--- For each column in the query --->
<cfloop from="1" to="#numCols#" index="i">
<cfset fieldname = md.getColumnName(javaCast("int", i))>
<cfset fieldsize = md.getColumnDisplaySize(javaCast("int", i))>
<cfdump var="#fieldname#">
<cfdump var="#fieldsize#">
</cfloop>

it errors on the getColumDisplaySize...
error is
getColumnDisplaySize()


The error occurred in ###show_table.cfm: line 89
Called from ###show_table.cfm: line 24
Called from ###show_table.cfm: line 1

87 : <cfloop from="1" to="#numCols#" index="i">
88 : <cfset fieldname = md.getColumnName(javaCast("int", i))>
89 : <cfset fieldsize = md.getColumnDisplaySize(javaCast("int", i))>
90 : <cfdump var="#fieldname#">
91 : <cfdump var="#fieldsize#">


If I comment out the line with the getColumnDisplaySize, I get the dump for fieldname, with the correct values...


Anyway...what am I doing wrong with calling this method?
Is there a better way to find the size of a field???

TIA,
--Suze

It's probably a private method so you can't call it from outside the object. I think you'll need to find another way to determine the column size.

just to tie this back up in case someone else is looking to do the same thing....

I ended up using a query against the ALL_TAB_COLUMNS system table in Oracle to find the column size...

SELECT DATA_LENGTH
FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = 'TABNAME'
AND COLUMN_NAME = 'COLNAME'
AND ROWNUM = 1;

That's what the system tables are for!