Search results for query: *

Can someone shed some light on this? I imagine it's just a setting somewhere, but it has me a little worried. I have a dev environment, running on a virtual server. I created a proc on it and ran the proc. All is well, so I move the proc up to our parallel environment, not a virtual server...

Does anyone know where I can find a table containing the P-Values of the Correlations used in the Probt function?

I'm trying to write a COM add-in for Outlook 2003 in VB.Net. I need figure out the full path to a selected email. Basically, if it's in the Inbox>Projects>Current Projects>Project 1 sub folder, I would like to be able to grab all that info. From there, I want to set a variable equal to...

Does anyone know the best way to dump large amounts of data from SQL Server to a text file, automatically? Here's the scenario: I have a web application written in ColdFusion, with a SQL Server backend. The application reads 7 mainframe files each morning. This information contains data on...

I have two data files that I need to merge into one table in SQL Server 2000. The layouts are below, * denotes key fields. File 1 (Order): State* Type* Cust #* FileDate* Customer Info Account Type (B or D)* Order (Y or N) File 2 (Usage): State* Type* Cust #* FileDate* Customer Info Account...

Does anyone know of a good VB to JAVA conversion plug-in/tool? I've looked around and found one at www.diamondedge.com, but was wondering if anyone has used any others.

I have an Oracle table that contains information on the control cards on our mainframe. The data in it looks like this: ROW_ID State Cust Type ID DETAIL_DESC ------ ----- ---- ---- --- ------------------------------------- 347621 AR COA A 10 SIGNON ESF=YES...

I'm finalizing a HUGE group Oracle project and noticed some of my fellow developers created some of their tables using non-standard data definitions when they created their tables. Since allot of data has been entered in these tables, simply dropping and recreating them is not an option. So...

I'm new to JAVA programming and especially Eclipse. I have a small program that runs fine, if I run it outside of Eclipse. However, when I run it from within Eclipse, I get this error: java.lang.NoClassDefFoundError: org/apache/log4j/Logger at java.lang.ClassLoader.defineClass0(Native...

I have a co-worker who is having problems returning a loooong string from an Oracle function. The results are being passed back in a recordset containing one column, but many records. It's truncating the results in each column at 1000 characters. Is there a way to increase this variable...

I'm trying to help a friend at work figure this one out. Here's the situation. He has the table below: Type Value A 1 A 4 A 6 B 2 B 3 B 7 What we need to do is query the table and create one output record for each Type. However...

Is there a way to join two tables, in such a way that values from one table can be properly associated with another, when one of the fields in a join will not match all the time? Here's my scenario: I have 2 tables, one has account information, the other has rate information. The account...

I need to import some data from an old Oracle table to anew one. In the old table, I have a field that contains a VARCHAR2(6) field. This field holds date data in MMYYYY format (I didn't design the original application). Now, I want to import it, but store it as a date. When I tried to do...

I have an Excel spreadsheet (703 rows x 263 columns) with program names for the columns and layout names for the rows. Whenever a certain program reads a particular layout, there is an "X" is the cell where they meet. What I would like to do is create a 2-column text file that...

I'm looking for a way to import data from Excel. The problem is that the data is layed out in a true matrix style. Basically, I have programs in the "1" row and layouts in the "A" column. When a certain program reads a layout, there will be an "X" in the...

Is there a keyword I can use to grab the last n characters in a field? I can do it using substring and octet length and such, but figured there has to be a better way. Anyone know? Thanks!

Has anyone ever had a problem with the prompt window not going away, not allowing the SQL to run? I have a report I'm trying to create/run, but when the prompt window comes up, it won't go away. It populates the values properly, and after all 3 have been selected, the OK button is enabled...

Is there an easy way to get the number of rows updated by a query? I'm trying to update a password table, and should only get one, but would think this would be useful in other areas as well. I'm working on SQL Server and CF 5 (patiently waiting to go to MX) Thanks!

Hello All! I'm trying to figure out the best way to execute a program upon any file being placed inside a network folder. We have TechScheduler, with which I can do 1 of 2 things. I can schedule a program to run every # minutes/seconds/whatever or I can just have a program that constantly...

Is there a way for a CF module to be executed upon a file being created on a server?? I have a mainframe job that creates a bill, then passes along information to a load job, also on the mainframe. The problem is that I don't know PL/I well enough to have enough power to process the file the...