Hi
I have method below that extracts the columns of a table, is there anyway
that the columns can come out of tbMap.getColumns() in the same order as
'DESCRIBE tablename' does in mysql. I am creating a dynamic data dumper that
will dump out column headings with all rows below in an html table,
unfortunately with the getColumns() method I do not know which order to
print out my Peer data when it is returned.
Or can anybody suggest another method of retrieving the column names?
/** Returns a Vector of the column names in a table
*/
private Vector getColumnNames( MapBuilder mapBuilder, String name ){
Vector columnNames = new Vector();
DatabaseMap dbMap = mapBuilder.getDatabaseMap();
TableMap tbMap = dbMap.getTable(name);
ColumnMap[] cMaps = tbMap.getColumns();
for(int i = 0; i < cMaps.length; i++)
{
columnNames.add(cMaps[i].getColumnName());
}
return columnNames;
}
Thanks in advance.
John Colvin
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.263 / Virus Database: 135 - Release Date: 6/24/2001
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
