Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jhall01
  • Content: Threads
  • Order by date
  1. jhall01

    Excel & Attachmate Timing?

    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)...
  2. jhall01

    Cant Enable Verity

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

    .db2 file extension

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

    db2 file extension

    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! :)
  5. jhall01

    Retrieving PID info

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

    Possible Unique Combinations

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

    Images missing in browser

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

    Close window after inactive

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

    DTSGlobalvariables & rowset

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

    Zip a file after DTS export

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

    output data into Excel Template

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

    Recover deleted Local DTS package

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

    Rank duplicates

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

    Line charts line weights

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

    spt_values "low"

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

    Track Table(s) size over time

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

    Parse a string in a SPROC

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

    Matching duplicate records

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

    text file import after upload

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

    CFFILE read text w/o upload

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

Part and Inventory Search

Back
Top