Search results for query: *

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

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

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

Hi, all. I have a report where its information is generated based on a single date value stored as the sole record in a table. When I try to display that date on the header of the report, I get "#Name?", instead. A little assistance would be greatly appreciated. Thanks in advance, TEM

Hi, all. I have two tables that have identical structure and different data. For eventual use in a report, I'd like to take the contents of each table and merge them together into one, in a query. Table 1: Fred 1 Jake 2 Bob 3 Table 2: Fred 1 Jake 2 Jane 4 Mike 3 Query: Fred 1 Jake 2 Bob 3...

Hello, all. I have two reports with identical structures but different source queries that I have merged together as subreports on one main report. On each of the subreports is a grand total field, and I would like to add a field to the main report that shows the sum of those two grand totals...

Hi, all. Got a funny one for you; I'm working on a "Basic Flowchart" in Visio 2002, and I accidentally closed the green Shapes window on the side of the screen. I cannot seem to figure out a way to get the window open, again. Any ideas? Thanks in advance, TEM

Hi, all. I have a function that I'm using to take null fields (such as the result of a left join) and convert them into zero. Here's my code: 'this function is designed to return an integer zero (0) 'if passed a null string: ("") or (null). It will return the 'original value if not null...

Hi, all. Got a quick one for you. Is there a way to make an Access Macro not ask the user if he or she is sure about deleting tables from a database and what not? In this case, I know that if the user clicks the button to start the delete operation, he or she doesn't need to agree to delete...

Good morning, all. I am using Crystal 10 and Access 2002, and when I attempt to open up a local database using the "Access/Excel (DAO)" option, I encounter an odd problem. When I expand the "Views", it does not display all of the queries that I have in my database. Is this a glitch in...

Hello, all. I have a database table where each record has an entry for a date. I would like to create a query (and then a report) that outputs this information in a variety of ways, but allows the user to enter the specific date to search for, by hand. I've worked with Access quite a bit, but...