On Thu, 2004-05-20 at 16:38, Dale, Matt wrote: > Adam - I mentioned this in another post but unless the result set is scrollable then > you can't reset it back to the beginning. You need to declare the statement object > as scrollable when you create it to achieve this. So Filip was right in that it wi
Matt, yes you did I just didn't get it until after I'd sent mine! I was just surprised because I've never run into that behaviour before and I've never changed the defaults. I'm sure you're right though, I probably set some global variable somewhere and forgot about it! > > -----Original Message----- > From: Adam Buglass [mailto:[EMAIL PROTECTED] > Sent: 20 May 2004 16:02 > To: Tomcat Users List > Subject: RE: Is there any way to check # of Records in RecordSet > > > First of all forgive me for being very stressed and tired - All I did > was put into some kind of code model a suggestion previously put forward > by Matt: > > If the result set is scrollable you can iterate through it counting > the number of iterations, then set it back to the start when > > you want to process the records. > > Second, I'm not sure whay Filip thinks it would only work once. Surely > you could put it in a method and call that method over again - Just make > sure you set it back to the start of the ResultSet each time! (I may > well be missing something here - please don't hesitate to point it > out!): > > If the cursor is non scrollable, this will only work once. > > However I do like the suggestion of getting it from the Database via a > new query. You should avoid too many loops in code (especially While > loops) - I'm afraid my SQL isn't quite what it should be! > > > I'm assuming your HTML output is also set for the first option? > > Assuming the function is successful, you should be able to use > <%=count%> in your HTML. > > If I know the precise list I would have given it to you! > As I said, go check on Sun's java site (http://java.sun.com ??) and look > for an appropriate messageboard on there, I think that's your best bet! > > > On Thu, 2004-05-20 at 15:50, soh_mah wrote: > > Thanks Adam :) > > > > First of all I subscribe to the list yesterday and I m > > new to JSP. Secondly could u plz tell me right list > > name so I can subscribe to that. > > > > Adam, I did exactly the same way u mentioned, but when > > I use like > > > > //----------- > > ResultSet rs = stmt.executeQuery(query); > > while(rs.next()) { > > count1++; > > } > > rs.first(); > > //----------------- > > > > it does not show me any thing on the page but when I > > use like this it shows me all records. > > > > //----------- > > ResultSet rs = stmt.executeQuery(query); > > while(rs.next()) { > > count1++; > > } > > > > ResultSet rs1 = stmt.executeQuery(query); > > > > while{rs1.next()) { %> > > > > Here is HTML <% > > out.println(rs.getInt("first_column")); } %> > > > > //----------------- > > Then it shows me all the records, what is wrong with > > my first code? > > > > > > > > > > > > --- Adam Buglass <[EMAIL PROTECTED]> wrote: > > > This is the wrong list but never mind > > > > > > An alternative is the following: > > > > > > ResultSet rs; > > > int i = 0; > > > while( rs.next() ) { > > > i++; > > > } > > > > > > The integer i should be the length of your result > > > set (by the way, don't > > > get confused with RecordSets which are VB - I used > > > to do that all the > > > time!) at the end of the loop - assuming of course > > > that you start from > > > the start of the set, you could use rs.first() to > > > ensure this. > > > > > > There's tons of useful info on Java methods and > > > classes on suns site: > > > http://java.sun.com/j2se/1.3/docs/api/ > > > http://java.sun.com/j2se/1.3/ > > > > > > Also look on www.sun.com for good java mailing lists > > > where this kind of > > > question is more specific. > > > > > > Adam. > > > > > > > > > On Thu, 2004-05-20 at 15:26, Dale, Matt wrote: > > > > This is the wrong list i'm pretty sure but there > > > are a couple of ways to get the number but there > > > isnt a direct method that returns it. > > > > > > > > If the result set is scrollable you can iterate > > > through it counting the number of iterations, then > > > set it back to the start when you want to process > > > the records. > > > > > > > > The other option (one I prefer) is to load the > > > records into an ArrayList, you can then determine > > > the size quite easily. > > > > > > > > If anyone else has any neater solutions i'd like > > > to hear them too as I've had to do this in a few > > > places. > > > > > > > > Ta > > > > Matt > > > > > > > > -----Original Message----- > > > > From: soh_mah [mailto:[EMAIL PROTECTED] > > > > Sent: 20 May 2004 15:20 > > > > To: [EMAIL PROTECTED] > > > > Subject: Is there any way to check # of Records in > > > RecordSet > > > > > > > > > > > > Hi > > > > > > > > Is there any way to check number of Records in > > > > RecordSet? > > > > > > > > > > > > ===== > > > > Regards > > > > > > > > Sohail Mahmood > > > > (416) 636-2553 > > > > > > > > > > > > > > > > > > > > __________________________________ > > > > Do you Yahoo!? > > > > Yahoo! Domains - Claim yours for only $14.70/year > > > > http://smallbusiness.promotions.yahoo.com/offer > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: > > > [EMAIL PROTECTED] > > > > For additional commands, e-mail: > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > ______________________________________________________________________ > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: > > > [EMAIL PROTECTED] > > > > For additional commands, e-mail: > > > [EMAIL PROTECTED] > > > -- > > > > > > Adam Buglass, ><> > > > The Golden Freeway, > > > Department of Child Health, > > > University of Newcastle-upon-Tyne. > > > Royal Victoria Infirmary. > > > > > > (0191) 2023062 > > > > > > "Democracy is two wolves and a lamb voting on what > > > to have for lunch. > > > Liberty is a well-armed lamb contesting the vote." > > > ~Benjamin Franklin, 1759 > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: > > > [EMAIL PROTECTED] > > > For additional commands, e-mail: > > > [EMAIL PROTECTED] > > > > > > > > > ===== > > Regards > > > > Sohail Mahmood > > (416) 636-2553 > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Domains â Claim yours for only $14.70/year > > http://smallbusiness.promotions.yahoo.com/offer > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] -- Adam Buglass, ><> The Golden Freeway, Department of Child Health, University of Newcastle-upon-Tyne. Royal Victoria Infirmary. (0191) 2023062 "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." ~Benjamin Franklin, 1759 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
