Search results for query: *

Here is my VBA code: Sub set_settleTime() xtraSettleTime = 3000 OldSystemTimeout = System.TimeoutValue If xtraSettleTime > OldSystemTimeout Then System.TimeoutValue = xtraSettleTime End If End Sub ... call set_settleTime ... With MyScn .SendKeys (npa)...

We are running the following Environment: RedHat Linux AS 2.1 ColdFusion MX 6.1 SunOne Webserver 6.0 J2EE We get a collection created and the K2Server started. We added the path on the Webserver JVM Path Settings, but we get the error on Coldfusion Administrator when we try to setup Verity...

I am trying to understand a custom App a client has that a company who went bankrupt built for them. There is a file within the app that contains the file extension of .db2, and all I can find on it is that it might be a precompiled DB2 SQL procedure Script. I have never used DB2 in my life...

What the heck is a *.db2 file? all I can find is that it is a dbase II file. If it is a dbase II data file how can I open? Can I get an ODBC Driver to open it? I have never used dbase(if it is in fact a dbase II data file) so please speak to me as if I were a child! :)

We have a system that was built for our group by a contractor before I was hired. It is the most horrifically designed system I have ever seen. 1 table, 140ish columns, some of which contain default data that isn't being used. 1 index on a identity seed. They did not normalize the info at all...

I have a table that with 1 column that I need to create a dynamic list of combinations 3 wide. Table: letters ------- a b c d e need to output: abc,abd,abe,acd,ace,ade,bcd,bce,cde I can only have a unique combination, so no matter the order the combination cannot be used again. This needs...

My roomate is having a problem displaying some images in Internet Explorer and Firefox. Recently alot of images on certain website's images don't load. It is not all only certain ones. excite.com news images listed in the center don't show up on the home page but the rest do! This happens...

I have a page that refreshes every 3 minutes but seems to be causing issues. We will most likey be takeing off the refresh and force the users to manually refresh the page. I want to be able to close the browser window if the user has not done anything in 15 minutes. any suggestions would be...

I am passing a SQL task recordset to a Global Variable. I know the SQL task returns 8 records. The data type gets set to "Dispatch" on the Global variable which I understand is correct after the first save and run of the package. Well If i output the Variable into a msgbox string it only...

Is it even possible. I have a DTS job that exports data out to an excel (looking to export to text in the future to reduce data size). Some of these files get upwords of 8-10 MB. I need to zip this in an automated fashion. any idea? I am going to eventually setup automatic emails to attach...

Challenge: Get a daily report for upper management in a specific format. What I have: I have a excel template with charts and tables. It takes aprox 5 minutes for each query I use to fill the tables that drive the charts. There are 5 tables to fill. Normally I would create an ODBC...

I have a DTS package that was saved on the SQL 2000 Local Packagew under the Data Transformation Services that got deleted by another admin. How can I recover??? is it saved in a directory on the server to recover from? Thanks, Jon

I have a recordset that comes back with duplicate customers because of purchase date. Since the dates vary i need to translate the duplicates out into columns. I want to rank the duplicates by date and only take 5 duplicates? Normally in teradata i would use a CSUM() or RANK() function to...

Ok, this i may sound stupid, but how can i increase the weight of all the lines on a chart at the same time. I have several line charts tracking 10 different categories and all I want to do is change the weight of the line to be thicker. Currently i have to select each one individually...am...

What does this column hold? I am using a query to track my table sizes and I take the low field from the spt_values table and divide it by 1024 to monitor table growth. I have noticed that sometimes I insert several thousand records and the size of the table decreases. I have also noticed...

Anyone know of a good stored procedure or code to track table size and growth over time in MS SQL 2000? I can pull the file size but don't know a good way to track table size. If i have to build a table that stores table sizes on a daily bases that would be fine. Thanks in advance! Jon

I have a text file that loads up on a coldfusion webserver which my Database can't see. I pase the contents to a variable in Coldfusion and then pass the variable to a Stored Procedure. I have the string passing correctly but I need to parse it within a Stored Procedure! any ideas. The...

I have a query that pulls back 4 records per order ID When a service is changed the old service goes out and the new service goes in. I need to match the in/out services per order. Example: OrderID name serviceID_out service serviceID_in service 1 Jon...

I use CFFile to allow my clients to upload a text file to a folder on the server. I then want to import the text file into an existing table. I can't put inserts into loops and have several other restrictions on my environment. The page process on the upload is this: upload a file to server...

Is it possible to read in a text file from a client machine without uploading to the server. We currently have comma delimited files sent via email to one person who then imports the files into the MS SQL SERVER Database because our agents don't have access to internal systems. They do have...