chicago1985

I just loaded the 10g client EM on my Windows workstation to connect to our 10g database. Everything works great except I dont see any place where I can edit records. I have to use SQL Plus to edit records but was hoping to use a GUI like I had …

-------------------------------------------------------------------------------- I have this test working where it takes data from a Java class and shows it in a JSP: [code] String targetItems = "test" List pageItems = New ArrayList; for(int i = 0;i < calculatedResults + 10;i++) { pageItems.add(targetItems + " " + i) } request.setAttribute(pageItems, "pageItems");[/code] I would …

I am getting closed exception messages with my below jdbc connection to Oracle 9i from Tomcat 6 container. The database connection is used about once or twice a day. [b]java.sql.SQLException: Closed Statement[/b] and [b]java.sql.SQLException: Closed Statement: next[/b] [code] private Connection connection; public ArrayList<MoneyBean> getMoneyList() { ArrayList<MoneyBean> list = new ArrayList<MoneyBean>(); …

I am trying to create a page where it will look the same if the screen is resolution 1024 x 768 or if the screen is resolution 800 x 600. The below finds the resolution but the page looks different depending on the resolution. Please advise how I can make …

I am using Apache Tomcat 6.0.18 on a Windows Server that also has IIS. For IIS I can enable Integrated Windows authentication to fetch the Intranet Windows login username using ColdFusion. Is there a setting in Apache Tomcat I need to enable Integrated Windows authentication so I can fetch the …

I have a ASP web application working with SQL Server. It has around 500 records and it works great. Now my management wants to redo the application for the 5th time in the last several months. The management knows nothing about web development and engineering. The management now wants to …

I have a PHP (version 5) site on a Windows server that allows uploading of files into our Windows server. I currently allow the user to upload up to 10 files at once. If users upload files as big as 20 mb or more slows the upload process down. Should …

I have web pages on a Windows 2000 intranet web server that uses IIS. Everyone has to use Windows Network login to get into the Intranet. I need to restrict who can view Intranet web pages which are located in this directory and also in subdirecties of this directory -> …

I use CFFile to upload files all the time on the same server Cold Fusion 8 is located on. Now I want to use CFFile to upload files on another server. Everytime I put in the destination directory for another server it fails saying it does not exist. For example …

I am using PHP 5.2.5 to insert record into Oracle 9i. For my database input I was getting two duplicate record inserts when I only needed just one record. Here is what I had: [code] require_once('oraConnect.php'); $query = "insert into cityTable values (1, 'George')"; $stmt = oci_parse($db_conn, $query); oci_execute($stmt);[/code] After …

For my Java class with resultset I am trying to get the request.getParameter value. Please advise if this is the correct way use the request object in a Java class because I cant seem to get any data from the request object. [code] ... import javax.servlet.*; import javax.servlet.http.*; ..... HttpServletRequest …

I am thinking of going with ColdFusion Enterprise over my current PHP. We do alot of web apps working with MySQL and Oracle. I have no problem paying for it compared with free PHP because I hear that ColdFusion can cut down my development and debugging time. It also seems …

Hi everyone, I want to retrieve data from database in jsp page based on the particular m_emp_no .I am finding it very difficult so please can you all help me out with the problem. Here is the structure of my database and i am using ms.access [ICODE]m_emp_no m_leavetype m_bal 1004 …

I have a Form input field in my JSP:[code] <input name="nickname" type="text" value="<%= NameClass.getInfo() %>" /> [/code] How do I make sure this data is escaped correctly to be able to show quotes and apostrophes. I tried slash in front [b](name=\"nickname\")[/b] and it didnt work. I dont have JSF,Struts, JSTL, …

I need to export 20 small records from one table in Oracle 9i into an xml file. Each record has 4 fields. Please advise if I can do that and what the command would be in sql plus.

I am trying to translate the PHP script into Java. If anything please advise what or how this translates? PHP: [code] if(isset($_GET['getClientId'])){ $res = mysql_query("select * from tableOne where clientID='".$_GET['getClientId']."'") or die(mysql_error()); if($inf = mysql_fetch_array($res) ... [/code] My attempt in Java and it is giving me errors with getClientId part …

I have [b]form.mydata[/b] coming to my action page with comma delimeter value: [b]adam,joe,ben,steve,jill,andy,david[/b] I want to seperate them and it works inside this loop: [code] <cfset myd = ""> <cfloop list="form.mydata" index="i" delimiters=","> <cfoutput> <cfset myd = "#i#"> #myd#<br /> </cfoutput> </cfloop>[/code] How do I get them to print outside …

Does a Database driver come with MySQL 4.0.1 database download? Or do I have to download additional software to get the ODBC driver?

I have a JSP that works with an Oracle 9i database. On my local windows workstation (using Tomcat) where I developed the JSP the application processes very quickly working with the Oracle database. The JSP application on the Production Intranet web server (Tomcat) connecting to the same Schema processes very …

I want to make sure at least 3 characters are entered into a search field. For example I dont want this to go by where it has spaces in beginning and space between 2 characters: [code] a b [/code] Is there a regular expression or someway to trim the spaces …

r CF MX 7 the CF admin setting for database queries timeout is set at 100. Because of this some of my queries timeout and give me back a timeout message. I am trying to overwrite it in my cfquery working with Oracle 9i: [code] <cfquery datasource="cityOra" [color=red]timeout="300"[/color] name="queryOne"> select …

I have all my webapps in Tomcat 4.1.27. All of them were compiled using JDK 1.4. Now I need to move the Tomcat 4.1.27 webapps to Tomcat 6.0.16. Do I need to recompile all my Java class files using JDK 1.6 before I put them on Tomcat 6.0.16?

What advantage does PHP have over Cold Fusion besides being free and Cold Fusion cost money. I see alot of examples of procedural scripts in PHP whereas Cold Fusion has MVC framework type Fusebox with its standard installation. Does PHP have anything like that with its standard installation?

I need to do an SSI include in my PHP web page located on a Unix web server, but cant seem to get it to work. [code] <!--#include virtual="http://anotherServer/thepage.asp" -->[/code] Please advise.

For the past 5 years I been using DSN connections to connect to Oracle in my Cold Fusion. Is there any other way to connect in Cold Fusion MX 7 without using DSN? <CFQUERY NAME="query_name" DATASOURCE="db_name"> SQL statements </CFQUERY> Maybe instead of System admins creating DSN, I can create the …

I have done a little PHP and end up using Model 1 architecture combining Model, View and Prensentation where it ends up looking like "spaghetti" scripting. For PHP, how would I use the equivalent of Java's MVC (Model 2 Architecture)? Is there a name for it in PHP and does …

I have my PHP inserting into Oracle 9i. But how do I prevent duplicate record entries? I only have 3 fields in the insert in the action page and my below attempt doesnt output anything or insert anything even if not a duplicate: [code=php] <?php $c=OCILogon("scott", "tiger", "orcl"); if ( …

I have a class that fetches a record but dont think I need to use List object because I am fetching one record and not an array of records. [code=java] public List getRecords(){ ResultSet rs = null; Statement stmt = null; Connection connection = null; List rows = new ArrayList(); …

I have a Servlet that checks for information and if there is an issue it forwards the message to presentation page (JSP). Now I want to stop using conditions in scriptlets in the JSP. Please advise how I can do it in this situation in my Tomcat 4.1.27 container. I …

I have a Date insert that is formatted into an Oracle 9i database and it works. But I had to make the Date variable a varchar2 in Oracle to get it to work: [code=java] java.sql.Timestamp myd = new java.sql.Timestamp(new java.util.Date().getTime()); String sub_date = new SimpleDateFormat("mm/dd/yy , h:mm a").format(myd); String query …