--- You wrote: Date: Mon, 15 Jul 2002 10:47:57 -0400 From: [EMAIL PROTECTED] Subject: datatype from QueryTable Message-ID: <[EMAIL PROTECTED]>
Is it possible to find out from the QueryTable object what are the datatype of the columns? I need it to be able to format the data returned depending on the type. Thanks! Zeina --- end of quote --- If you are returning a result set, the java.sql class ResultSetMetaData has methods getColumnType, and getColumnTypeName that return the data type as an int, or String. Once you get this, then you can format your data based on the type returned. Hope this helps. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
