Search results for query: *

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

Hi, Srinath. Thanks for the speedy response. I will have to check on that value and ensure that it hasn't been mucked with. The reports have run, before, but have never run at the right time and have never all run successfully. Last night, however, was the first time everything failed. None...

Hi, all. I've got a really frustrating problem with my Enterprise server. I have a few jobs that read data from an Oracle database through ODBC. They do not run as scheduled. When I say that they "do not run", I mean that they never enter a "pending" status nor does it appear thay they fail...

Hi, all. Thanks for the tips. Unfortunately, I was trying to use a windows scheduled task as a way to cheat the report into behaving as if it were on Crystal Enterprise. I guess I'll just need another method.

Hi, all. Quick question for you. Is it possible to make a Crystal Report refresh its data automatically when I open it in Crystal Developer? Thanks in advance! Regards, TEM

Hi, all. One of the applications that I've been working on consists of about 50 "state tables" that are all related to each other. Starting with the first table to be accessed by the program, I am creating a flow chart that shows the dependencies between all of the tables. The problem is that...