Getting Field info

[kensington43]

How can I output this method where I use a for loop to show all the fields:


Currently I am doing it this long way to get the Field info:

while (rs.next())
{
    ResultsetMetaData rsmd = rs.getMetaData();
    String myField1 = rsmd.getColumnName(1);
    String myField2 = rsmd.getColumnName(2);
    String myField3 = rsmd.getColumnName(3);

out.println(myField + "," +  myField2 + "," + myField3);
}

My attempt doesnt seem to work because I think I am not correct with my Types?

while (rs.next())
{
    ResultsetMetaData rsmd = rs.getMetaData[20];
    for(int i = 0;i < 21;i++)
    {
        String myField[i] = rsmd.getColumnName(1);
    }

out.println(myField1 + "," +  myField2 + "," + myField3);
}

 

[LFI]

Doesn't getColumnName[red]s[/red]() return the fields in an array?

Dave


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
O Time, Strength, Cash, and Patience!

 

[venur]

Hi

Hope this will help you

http://www.tek-tips.com/viewthread.cfm?qid=1113303

Cheers
Venu

 

[kensington43]

Thanks it works great.