Can anyone throw some light
//My program display some silly results. I put the following statement:
"SELECT * FROM Reports WHERE DateOfPurch = '"+jtfDate.getText().trim()+"'";
//then tell it to append those results to a text area using the following:
int result = new StringBuffer();
ResultSetMetaData metaData = rst.getMetaData();
int numberOfColumns = metaData.getColumnCount();
for(int i = 1; i <= numberOfColumns; i++)
result.append(metaData.getColumnName(i)+"\t");
result.append("\n");
while(rst.next())
{
for(int i = 1; i <= numberOfColumns; i++)
result.append(rst.getObject(i)+"\t");
result.append("\n");
}
//but after the third column it starts displaying data in an unordely manner i.e. leaving some unneccessary spaces.
