Getting column names

Hi all,

I need to validate request.getParameterNames() against the actual fields in a particular table but I can't figure out how to query the DB for just the field names...

SHOW columns FROM myTable; returns too much junk...I just need the field(column) names.

There must be an SQL statement which would accomplish this huh?

Any suggestions?

In case it makes any difference, I'm using mysql.

TIA,

Brad

[460 byte] By [brads] at [2007-9-26 7:06:52]