Build a table dynamically, if you know there will be only one resultset (with SP's and multiple result sets, this can get tricky, but not impossible).
Look at the ResultSetMetaData and from there you can get the column headings and number of columns. Then its easy to populate the table from there on further. The SDK javadocs give full details what you can do with the ResultSetMetaData ... --- "Mehta, Chirag (IT)" <[EMAIL PROTECTED]> wrote: > Hello, > > I am developing an application where the user can > run SQL queries from a > text area on a JSP page and the application returns > the results. > > As I have no idea what the user will input and the > database they will be > connected has many gigs of data, with plenty of > column, how should i > handle the result set from the database? > > I cannot define set methods as I have no idea what > the return will be > and might be very large? > > Can anyone help? > > Thanks > > Chirag > > > > > > -- > NOTICE: If received in error, please destroy and > notify sender. Sender does not waive > confidentiality or privilege, and use is prohibited. __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
