Susan, Hard to provide an answer without knowing for sure where the nullpointer is coming from, but I can see no reason a JSP page can't make 100 database calls at one time. Could you explain the workings of the page a little more? When is the second query being made? Dan > ---------- > From: Susan Holden[SMTP:[EMAIL PROTECTED]] > Reply To: Susan Holden > Sent: Wednesday, September 29, 1999 9:45 AM > To: [EMAIL PROTECTED] > Subject: Re: executing 2 different queries from a single JSP > > Hello all, > > I don't have any problems getting the results from a database diplayed in > my > browser. However, I am having problems executing 2 different queries from > a single JSP. I have in my page resultset and other variables set to > null. > Then I execute the query. This works fine for just one querie. Further > down > the page I then reset everything to null and re-assign things and execute > the > second query. My goal is to display both results sets in the browser. > I end up getting a NullPointer exception. But when I print out to see what > my > variables are they are not null. So the problem seems to be with my > connection. > The scope is session so I shouldn't be losing it. My connection and > execution > commands are in beans that I call from my page. Does anyone know why > trying > to execute two sepearte queries would give my an exception while > connecting > to the database? I would greatly appreciate this since I have a very tight > deadline! > > Thanks in advance!!!! > > Sue > > I Khaitan wrote: > > > You can access the individual fields in the resultset by calling > resultset's > > get mthods eg. getString( ). getString method is overloaded and takes > column > > name(String) as well as column index(int). There are other methods as > well > > for some data types. > > > > Hope this helps > > -khaitan > > > > ----- Original Message ----- > > From: Shrikumar R <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, September 28, 1999 2:17 AM > > Subject: displaying the contents of a rs > > > > > Thanks all for the help with my previous question. I > > > managed to instantiate my bean, I mean the java bean. > > > Here is another one. I successfully retrieve the data > > > from my database in to the record set in my java bean. > > > Now I am trying to display these data in a html format > > > in my jsp page but am not able to do so properly. Can > > > somebody please tell me how to refer to a specific > > > field in this recordset. for example if I do a select > > > * from... but I want to display only some fields from > > > the result set. Also can somebody tell me where I can > > > find some docs on this database manipulation. > > > > > > Thanks in advance > > > > > > Shri > > > > > > > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Bid and sell for free at http://auctions.yahoo.com > > > > > > > > > ========================================================================== > = > > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > > FAQs on JSP can be found at: > > > http://java.sun.com/products/jsp/faq.html > > > http://www.esperanto.org.nz/jsp/jspfaq.html > > > > > > > > ========================================================================== > = > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > > FAQs on JSP can be found at: > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.html > > ========================================================================== > = > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > FAQs on JSP can be found at: > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.html > =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". FAQs on JSP can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html
