Re: Querying a Database in JSP.

2001-02-11 Thread John Smith
In the code that I'm writing we use a cleanup/finalize method to drop the db connection. After the handler creates/executes the pstmt we close the connection (yes, I'm using connection pooling) I'm assuming the same is done automatically when you query within the JSP, if not would you just use th

Oracle Connections

2003-01-16 Thread John Smith
I'm sorry if this is rather a basic question for the list, but I am just getting started using JSP to front-end an Oracle server. I can successfully connect to the database and produce HTML pages full of data, but before I can make any real use of this I have to implement security. What I think t

Re: displaying 5th record

2003-06-03 Thread John Smith
If you want to find the last five records, you will *have* to use a condition to define which they are. Remember that there is no defined order in a relational database, you must specify one when you require one. If you mean the five records most recently entered you will need to store the entry

Re: Carriage return and html

2004-01-20 Thread John Smith
Declare an integer variable, increment it each time that you find a tag, decrement when you find a . Only output a if the variable is zero. This will correctly handle nested tables. Depending on the source of your HTML, you may need to ensure that is also handled - HTML is not case sensitive

JSP Tools

2004-07-15 Thread John Smith
I use an Oracle database running on HP Unix. Currently I am working to migrate all of the UI to web based, thus giving my PC support colleagues the thin client they would prefer! So far I have been using vi to create all of the server side scripts, but I can see a lot of work ahead. Now I get to

Re: JSP Tools

2004-07-21 Thread John Smith
r > Visual Servlets, JSP, and Struts designers really lower the amount of code. > Plus, it has a nice integration with JUnit that helps with the unit testing. > > ----- Original Message - > From: "John Smith" <[EMAIL PROTECTED]> > Sent: Thursday, July 15,