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!

  • Congratulations strongm 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: dfrazell
  • Content: Threads
  • Order by date
  1. dfrazell

    Shut Off Audio on Flash Movie

    I have a flash movie that plays on a web site and I need to prevent the audio from playing for everyone who visits the site. Is there a way through the html parameters to shut off the audio? I believe the flash object embedded in the html codes is: swflash.cab#version=8,0,0,0. Thanks - Dave
  2. dfrazell

    Find Unmatched Records in Same Table

    How can I find all the unmatched records in the same table? I need to find all the parts that aren’t setup in a second warehouse. The table contains a record for each warehouse and part combination. The unique key to the table is WH_ID and PART_ID. Example: Table Name: WH_PART WH_ID &...
  3. dfrazell

    HTTPWebRequest - 401 Unauthorized Error

    I’m trying to run a VB.NET console application on a Windows 2003 server running IIS 6.0 and I can’t seem to get the authorization correct for it to run. When I execute the console app from the server I get the following error: The remote server returned an error: (401) Unauthorized. What is...
  4. dfrazell

    Strange Message Routing - How Did This Happen?

    Two users received the same email that wasn't addressed to them directly. It was addressed to user3@companyname.com who is no longer with the company and their user account has been deleted (as far as know.) I reviewed the message header and it was addressed to user3@companyname.com. No where...
  5. dfrazell

    Refresh Page Sections with AJAX

    I have a dashboard application using AJAX to build and display 5 or 6 tables of information. Each dashboard item can be refreshed independently of the other items, via a refresh button, without refreshing the entire page. How can I make these items refresh automatically at different intervals...
  6. dfrazell

    Modellog.ldf Growing (26GB+)

    I’ve never really paid any attention to the properties on the model.mdf database but I just noticed the modellog.ldf file is greater than 26GB (because the recovery model is set to Full and the transaction log isn't being backup). I'm running SQL 2000 with SP3a. 1. If the model.mdf database is...
  7. dfrazell

    SQL Views with UNION Performance

    I currently have 8 identical SQL 2000 databases, one for each regional office. I need to build some reports where I can pull data from all 8 regions so I'm considering creating SQL Views with Union operators for 4 or 5 specific tables. Is this a decent solution? Will these views impact the...
  8. dfrazell

    Move Child Records to New Parent and Update key

    I have a customer manager application I’ve built that I need to write a utility to move customer contacts from one customer to another. For example, if I have customer ABC and I want to move the contacts to customer XYZ. Customer ABC CRMID ContactID Name Phone 1111 1 Bill...
  9. dfrazell

    SQL Update with Table Join Syntax

    I need to update the production date field (PROD_DATE) in my Work Order table (WORK_ORDER) based on a unique join on Order Number to an intermediate table (WO_LINK). The WO_LINK table provides the unique information to update the correct Work Order record. The order number and the production...
  10. dfrazell

    Trigger vs Two Inserts

    I have a table that new customers are added to through a stored procedure. When a new customer is added to the Customer table their customer ID also needs to be added to the Customer Summary table. Should I just add a second insert in my stored procedure for the Customer Summary table or...
  11. dfrazell

    Preserve Selected Tab Between Refreshes

    I don't know if this is a javascript issue but I'll start here. I have a page that has three tabs across to display different content for each order number displayed below on the page. For example, tab 1 shows customer info, tab 2 shows dates, tab 3 shows acct mgr info. If the user is viewing...
  12. dfrazell

    Increment Record Identify on Import

    I'm writing a stored procedure to import customer contacts from an import table into a master customer contact table. I'm having difficulty figuring out how to increment the contact identifier (ContID) for each contact within a customer. For example if the import table looks like this: CustID...
  13. dfrazell

    Reload Frame Error

    I have a page with a Top frame (Top), Left Navigation frame (Nav), and a Main Content frame (Main). In the Nav frame I have a drop down list to select a Sales Region and I need to refresh/reload the Main frame with the selected region when a new region is selected. When I do this I get the...
  14. dfrazell

    Change Tab Text with Record Count

    I'm trying to display the record count next to tabs on my web page that switch the view when clicked. For example I have | Tab A (x) | Tab B (y) | Tab C (z) | on my web page where x, y, and z represent the number of records that were written to the page. My problem is I don't have the record...
  15. dfrazell

    Exec SP within another SP Performs Poorly

    I have SP1 that runs on its own in 4 to 5 seconds and returns 200 or 300 records. I now have SP2 that executes SP1 so I can perform other processing on the record set. I've let this run at night for over an hour and it will finally complete. I don't understand why it takes so long or how to...
  16. dfrazell

    Restore Table Tag Style

    I inherited a style sheet that changes the style of the Table tag; TABLE {width:100%; border-collapse: collapse;} This is adversely affecting a new page I’m laying out. How can I override the style back to a default, as if this style was never declared in the CSS file? I can use a class...
  17. dfrazell

    Export to Excel Missing Stylesheet in Firefox

    I have an ASP page that creates an Excel spreadsheet report using Response.ContentType = "application/vnd.ms-excel" and building the output with a series of TABLE, TR, and TD tags. Most of the cell appearance (color, boxes, etc.) comes via a stylesheet. When I use IE6 or IE7 everything is fine...
  18. dfrazell

    Type Mismatch on Array Returned by Function

    I'm getting a '800a000d' Type Mismatch error when I try to return a 2D array from a function. I'm passing in LineArray, sorting it and returning it. What am I missing? dim LineArray (2, 19) ... LineArray = SortArray (LineArray, 0) ... ------------------------------------------ function...
  19. dfrazell

    Disable Radio Button Behavior Different (IE vs FF)

    I have an asp form application that changes available radio button options based on the report a user selects. When a user selects a report, different radio buttons are enabled and disabled and the default radio button is changed. This seems to work and displays correctly in Firefox but in IE7...
  20. dfrazell

    Find Unmatched Records by User and Program

    I need to find all the programs that a user is not authorized to. Table A is the list of available programs and Table B is the list of programs a user is authorized for by user. Table A - Program list PrgName ---------- OrderEntry Inventory Manufacturing Scheduling Shipping Purchasing...

Part and Inventory Search

Back
Top