Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by evergrean100

  1. evergrean100

    Customize message on insert or update

    Anyway to create my own customized message after a insert or update in a Oracle 9i table? Here is my trigger attempt: DECLARE city varchar2(100); Begin if city is null then RAISE_APPLICATION_ERROR(-20000,'NO DATA ENTERED'); end if; end; This trigger did output a message on a blank insert...
  2. evergrean100

    Prepared Statements

    Thanks, good info. I assume from your example the queryparam is equal to a preparedStatement in Java.
  3. evergrean100

    Prepared Statements

    Does Cold Fusion support PreparedStatements? I use them in Java and was wondering if Cold Fusion also has them for SQL inserts and updates into Oracle and Access databases?
  4. evergrean100

    Database helper class and closing

    Thanks for the information from both of you! The program will only insert one city at a time. I assumed I was closing the connection from cityInserter method which is why I have a closed statement in the dbMethod. If I close directly in the cityInserter method the insert doesnt work. Also I...
  5. evergrean100

    Database helper class and closing

    Where should I close it if not the finally block?
  6. evergrean100

    Database helper class and closing

    Thanks, I did some research and found it is not a good idea to put a Database connection in a Constructor. I changed it where I combined the classes: public class DbWork { private Connection connection = new ConnectionMgr().getConnection(); private PreparedStatement stat...
  7. evergrean100

    Tomcat in Solaris

    Does Apache Tomcat (not sure what version) come already loaded in Solaris 10?
  8. evergrean100

    Tomcat with Solaris 10

    Does Solaris 10 come with Tomcat container already loaded and ready to go where I can create JSP and Servlets?
  9. evergrean100

    Database helper class and closing

    I have a JDBC working with Oracle 9i in my Tomcat 4.1.3 Container. The Database classes I have used for the past year are working great but I wonder if I should be closing anything in my database helper class with Prepared statements: public class DbInsert { private PreparedStatement stat...
  10. evergrean100

    Send email with Form info

    Also, by the way that link you gave me is an excellent place to start because I used it (with some modifications) for my form validations because I cant get Struts at this time.
  11. evergrean100

    Send email with Form info

    Thanks, I ended up using an Array in the action page and listing the info from it. I was going to use Enumeration but it didnt guarantee order like I needed.
  12. evergrean100

    Cold Fusion has MVC?

    Thanks, can you recommend any links or tuturials of calling Java classes in Cold Fusion.
  13. evergrean100

    Cold Fusion has MVC?

    Java has the MVC (Model View Controller) with JavaBeans, JSP and Servlet. What is Cold Fusion equivalent of Model View Controller architecture?
  14. evergrean100

    Send email with Form info

    I have a Form with 10 fields on it and I need to send an email with all 10 field values. The email output will look like this: First Name: Joe Last Name: Smith City: Dallas State: Texas .... The form will pass the values to a Servlet which will call a JavaBean class that will get the values...
  15. evergrean100

    Combine methods

    I have 2 methods working in my class file that I am trying to convert into 1 method: ..... public Preparestatement prep; public int inserterOne(TheBean mybean) { int status = 0; try { prep.connection.preparestatement("insert into person (city, state) values (?,?)")...
See more

Part and Inventory Search

Back
Top