Recent content by evergrean100

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...

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

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?

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...

Where should I close it if not the finally block?

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...

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

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

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...

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.

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.

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

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

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...

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 (?,?)")...