Search results for query: *

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

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?

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

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

I have the same results with SQL statement in my Database class file several times and was wondering if I can make it into a method? public somemethod() { ResultSet results = null; Statement statement = null; ... //next two lines are repeated several times in different methods in this class...

Is it okay to create 3 different ResultSets with the same Statement object? Here is what I am currently using in my Database statements with Oracle and everything works great. But I am wondering if this will create Database resource leakages or other issues: //Db connection called from...

How can I combine the two below queries in Access 2003 where I need to know if none, one or both of the queries got a hit from form entries taken from a Web page: select * from mytable where firstname = 'formvariable.pocfirstname' and lastname = 'formvariable.poclastname'; select * from...

I am trying to make sure I know what exactly is meant by the Model part of MVC design pattern. Model is where you have the Business rules. For example if I had a Form in the Presentation part (JSP) that had a Field entry called Street and I only wanted the user to be able to enter one of three...

When I open up an Access 2003 Database it just shows a form with data in it. How do I see the Tables? I checked all the tool menus in the top part and none let me view or get rid of the form so I can see the actual Tables. Please advise.

I have a Form with an POC Firstname, POC Lastname and Expert Firstname and Expert Lastname. Sometimes the POC and Expert are the same person. <form ....> POC firstname: <input name="pocFirstname"....> POC lastname: <input name="pocLastname"....> Expert firstname: <input...

Next week my Server admin will register an SSL certificate for our Intranet Web Application located on a Windows 2000 server. I assume that the certificate will cover the all sites on the domain. So when I want to secure a web site it would have the https...

I have a JSP that outputs 10 links and it works great but want to cut down on the scriptlet lines in my JSP. Now I want to put the for loop that outputs the 10 links into a source file and call the class in my JSP using just one line scriptlet. Here is what my current JSP looks like where it...

I just installed and created a new Oracle 9i database on my Windows Workstation. I am using Sys to log in as sysdba. I see there are many example schemas that were already built but I now want to create my own user/schema. Please advise what the commands are to do this? I assume this is...

I have protected pages using MX 7, where only people that are logged in can view the pages. The problem is if I have a Cold Fusion protected page up in the first browser and I open a second browser in IE the session goes away in the first Cold Fusion Browser page. For example I log in and...

I have a CF MX 7 application with a form where users enter their Social Security number and Date of Birth. I am using CF to encrypt the information in the Access 2000 database. I was wondering if I need to request a certificate for SSL on our Windows Web server so we can protect the...

I have a validate method that works and now I want to condense it into a for loop. Here is what I have: //firstname and lastname are declared earlier public boolean validate() { boolean allOk=true; if (firstName.equals("")) { errors.put("firstName","Please enter your first...