Search results for query: *

Thanks it works perfect. I added left join for TableNotes to handle a missing related record. Is Query Design Window the same as Access 2003 Query wizard?

Thanks it works great! I was wondering if I have a third (and final) table called NotesTable how would I include that in the query?? For example if I query for MID number 3, I should get this: Firstname Lastname Firstname2 Lastname2 Info Notes Joe Smith Bill Carson...

I have two Access 2003 tables: TableMain MID PO TE INFO 1 2 3 ABC 2 2 1 EREER 3 1 3 OIUOI 4 3 3 PERE 5 2 2 DFE TablePerson PID FIRSTNAME LASTNAME 1 Joe Smith 2 Cal Jones 3 Bill Carson I would like to...

We just got a new Solaris server with Solaris 10 and now all my Perl CGI pages that were on the old Solaris server with Solaris 7 dont work in the new Solaris 10 server cgi-bin. I get a generic error saying "Internal error". Please advise any suggestions I can suggest to Server Admins to make...

Thanks for all the messages! I will follow all the advise and not shorten it.

I have a PreparedStatement with alot of values to insert into an Oracle Database. Anyway to shorten the setString lines in a loop or any other way to shorten this?? //Database connection part here //...... private PreparedStatement stmt; public void houseMethod(BeanInfo theObject)...

Thanks, it works great.

Thanks, I am using Java 1.4 in Tomcat 4.1.3 container without any EL or JSTL. How would I do the same with Scriptlet?

How do I keep Radio button values and not lose them after a Form is submitted? I have no problem keeping text values where a form is submitted and if there is a validation issue with the text value it takes me back to the Form and shows the Form text value that was submitted. With Radio buttons...

I am always checking if any of my Java Web applications have any Database leaks with our Oracle 9i database. Here is what I use in SQL Plus: select username, program from v$session where username = 'myUserSchemaName'; If I dont close my connections and do alot of inserts and updates in my...

I have a method that has a prepared statement that executes before a SQL select max id query. The Prepared statement works great where I call it in another method in my Java Helper Class file. Now I want to move the method with the prepared statement into another class and call in in my Java...

sorry error in my post. Here is the correct info: public int mymethod(MyBean theobject) { //db connection part here String query = "SELECT * FROM UserT " + "WHERE firstname = '" + theobject.getFirstname () + "' and lastname = '" + theobject.getLastname() + "'"; Statement statement =...

I have methods that call the same ResultSet statement and was wondering if I can put the ResultSet into a method and call it instead: public int mymethod(MyBean theobject) { //db connection part here String query = "SELECT EmailAddress FROM UserT " + "WHERE firstname = '" +...

Thanks, I changed it in my Access 2003 database as you suggested. The form entry will have an area for Point of Contact and another form entry for Expert. So it would look like this in my Web Front end: POC firstname: <input name="pocFirstname"....> POC lastname: <input...

Here is what I have for creating a Schema: - Point of Contact Name - Point of Contact Phone - Expert Name - Expert Phone - Project Name - Project Location On some occasions the Point of Contact Name will be the same person as the Expert Name. For the Schema I am looking at this: ContactTable...

Thanks, I tried that and it gave me a null exception pointer. Any other ideas?

I have objects that I pass from a Servlet to JSP using RequestDispatcher type. Now, I was wondering if I can do the same with a link but not sure how I do that: Servlet called MyServlet.java (or MyServlet in web.xml mapping): String firstname = request.getParameter("firstname"); String...

Thanks

Thanks, I tried that and it said "insufficient priviledges" after I tried the "connect / as sysdba" connection.

Tom, Thanks! That worked great.