Scott,
You should save the query parameters in your user's session. You can
then append additional query parameters to it and re-run the query when the
text field is submitted. You do not need to do a commit, since as far as
understand your situation, you are just querying the database and not doing
an INSERT or UPDATE. Only if you are changing data in the database, and
were doing this in multiple steps, would you need to start a transaction and
then commit the changes when you were done. The purpose of encapsulating
database writes into a transaction is to be able to ROLLBACK the changes if
a problem occurs before the last change is written.
-Richard Yee
-----Original Message-----
From: Scott Fitzgerald [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 11, 2000 6:57 AM
To: [EMAIL PROTECTED]
Subject: Re-running queries in the same page.
Greetings everyone,
I am filling a list from a query to show current results. I am also
providing a text field in which the user can enter a name to add to the
list. On 'submit' I want to update the list and have the update reflected
immediately in the list from the original query. How can I re-run the
original query after I do the update query? Can this be done in one page? Is
a 'commit' necessary at this point before the list can be updated?
Any help would be greatly appreciated,
Scott Fitzgerald
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
