Recent content by TheElephantMan

Hi, Skip! This is great; thanks for the help. I do have another question, though; how do I calculate the difference in time and the lag? When I create a formula with an end time minus a start time, I get weird results: P1Start P1End P1Dur 1/2/08 18:00 1/2/08 20:00 1/0/00 2:00...

Hi, all. I've got some data points that show the start and end times of a few of our nightly processes, broken down by date: Date |P1Start|P1End|P2Start |P2End|P3Start |P3End 1/2/2008|18:00 |20:00|22:00 |00:00|02:00 |04:00 1/3/2008|17:00 |19:00|21:00 |23:00|01:00 |03:00 ... I'm trying to make...

Hi, all. That's exactly what I was looking for. It's been a while since the last time I've done DB programming, so there's plenty of rust. I should have known that. :-/ Thanks for the help! TEM

Hi, all. I know that when I run OdbcCommand.executeNonQuery(), it returns the number of rows affected. However, is there a way to also get the error message that the database on the other end is broadcasting? For example, if I attempt to insert a record with a primary key that already exists...

Nevermind, all. The issue was that the begin_date attribute was not in the request when I was trying to reference it. I was looking for it in the wrong place. Elephant out.

Hi, all. In one of the components of my "Controller", I have a piece of code that adds a java.util.Date to my request scope: request.setAttribute("begin_date", resp.getBeginDate()); Then, one of my "View" components retrieves this attribute, and copies it into another local bean: <bean:define...

Oh, duh. That shows you how long it's been since I've done web programming; I was confusing that with the <title> tag on the page I'm trying to open in the window. Works like a charm, thanks! TEM

Hi, all. I have an innocuous line of code in an internal site that I'm developing that allows us to keep a close eye on the mischief that one of our systems gets into. There's a summary page that lists errors in an HTML table, and then each error links to a detailed piece of text, in a popup...

Hi, all. Up here at Acme Widgets, we're using Apache Tomcat as part of a fancy IVR application that sits over our call center. Throughout a typical Production day, one of the log files will occasionally indicate that our IVR application's context is reloading. Looking through the Tomcat...

Hi, all. I'm working on a project to build a flow chart of some of our PBX telephone menus. I will be using Visio for this project, and some of the flow chart steps involve voicing announcements at certain points, such as, "For quality purposes, this call may be recorded." I have an Access...

Hi, all. I have two tables that resemble the following: PROJECTS project_id|project_name ----------|------------ 1 |fix mainframe 2 |rebuild warp drive CHANGES project_id|change_number|change_details ----------|-------------|-------------- 1 |1 |drained...

Hi, all. Pardon my command line ignorance, but I'm at quite a quandary with some information I'm trying to gather from one of our AIX boxes. 1: If I have a process ID, is there a script that I can execute that will display the user that is running that process? 2: Along similar lines, if I...

Hi, again. Well, ultimately what I'd like to do is copy the contents of a table in Oracle into a new table, created dynamically, in SQL Server. I'm somewhat limited in my accessibility to both environments, so I'd planned to use a Java program as a shim between the two databases, and connect...

Hi, all. I think I misworded my question! Unfortunately, I will not actually know the column with and contents of what I'd be inserting into a table. It would be akin to how Access allows creating a table based on copy and paste or entering data. Can something like that be done in SQL...

Hi, all. Is there a way to create a table based on the contents of an insert statement? Something like... MAKE TABLE (VARCHAR NAME, INTEGER ID) FROM SELECT * FROM USERS; Pardon my rusty pseudocode; I've been away from traditional RDBMS' for too long. :-/ Thanks in advance! TEM