there is this package called java.sql in which there is this interface
called DatabaseMetaData which can be used to get the properties of the
table column. it gives you the datatype, null/not null anything and
everything basically.
call the method
|-----+-------------------------------------------------------------------|
| Resu| getColumns(String�catalog, String�schemaPattern, String |
| ltSe| tableNamePattern, String�columnNamePattern) |
| t| |
|-----+-------------------------------------------------------------------|
which reurns a resultset
check this out it is usefull.
do let me know in case you face any difficulty in implementing this
sanjeevi
Zafif@worldba
nk.org To: JRun-Talk
<[EMAIL PROTECTED]>
cc:
07/15/2002 Subject: datatype from QueryTable
08:17 PM
Please
respond to
jrun-talk
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
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
