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 TouchToneTommy 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: ideasworking
  • Content: Threads
  • Order by date
  1. ideasworking

    refresh linked server?

    Hello, Has anyone come up against a problem with an SQL 2000 server losing it's connection to a linked server even though the linked server is healthy? I have this problem. It seems every once in awhile the connection between the servers times out, hiccups, or something and then I have to...
  2. ideasworking

    images slow to load

    Hello, I'm trying to tailor my web pages to suit end user screen size. Now my pages are loading like I'm using dialup. I'm new to javascript so maybe I've done something wrong. Anyone care to review my code? TIA, Lou <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"...
  3. ideasworking

    Arithmetic overflow error converting varchar to data type numeric.

    Hello, I could use some help identifying a problem with my stored procedure. This stored procedure subtracts the values from two tables and updates a third table with the result.... er well, that's the way I want it to work. All three tables have datatype numeric (18,1). The value in...
  4. ideasworking

    mssql_query to delete not working.

    Hello, About a week or so ago I upgrade PHP to version 5.2 and ever since I have had trouble with mssql_query. I'm trying to delete a record and the query fails to delete the record. The query looks fine it's.... Here's my code. Any idea why this isn't working? Thanks, Lou...
  5. ideasworking

    record locking with PHP and MS SQL

    Hello, It seems I have created a bit of a cluster bleep... and I need some help sorting it out. Here's the situation. I have a table that updates the most recent record every minute. However there are times when I need to manually update the same record. When I attempt to manually update the...
  6. ideasworking

    FTP being hammered by...

    Hello, I was looking in the event viewer and I see that over the past several days someone has made about 80,000 attempts to gain access to my Win2003 server via FTP. I could block the FTP port at the firewall... but to be honest I'd like to keep it open as I often FTP to this server. What else...
  7. ideasworking

    MS Query doesn't work after upgrade to PHP 5.2

    Hello, This morning I upgraded PHP to version 5.2 Now none of my update queries work. Any idea why the queries stopped working? What should I look at to correct the problem? Thanks, Lou
  8. ideasworking

    Authentication in url?

    Hello, I have a website that requires authentication to gain access. Access is restricted to user accounts on the Win2003 server. This is great to prevent the public from browsing the site... however internally I would like bypass the authentication requirement. So I'm wondering if there is a...
  9. ideasworking

    Can't see web page on server - Failed Authentication

    Hello, I have a strange problem... from any workstation inside or outside of the local network I can authenticate to IIS and see my web site. However when I try to browse to the same web site from the actual Win2003/IIS server, authentication fails and I am unable to see the web site. Can...
  10. ideasworking

    PHP-MSSQL user event notification

    Hello, I have a form that adds records to a MsSQL database; the submit action loads a page UpdateRecords.php which contains the code to update the records and then redirects the browse back to the original page. Everything works great, however I would like to give the user some feedback as to...
  11. ideasworking

    Passing a variable to a function

    Hello, I could use a little help with a function. I wrote a function that should update the value in a text box named "CityUsage" depending on the state of a checkbox However the code just isn't working. Can someone help me identify the problem? Here's my function... <script...
  12. ideasworking

    Enter key action

    Hello, Is there a way to change the [Enter] key function depending on the focus? I have a form with two text boxes. When the user enters data in the first box and presses [Enter] I would like the focus to move to the next text box. Once that box is filled and the [Enter] key is pressed I would...
  13. ideasworking

    dynamic data?

    Hello, Is there anyway using PHP to have a calculated value updated on a page as a value is entered into a text box? What I want is basically three text boxes. A) Yesterdays value B) Todays value C) The difference. I'm sure this can be done with java but I don't have a clue of how to write...
  14. ideasworking

    Help with query please

    Hello, I would like some help with a query. I have a fairly simple table with three fields 1)DateAndTime 2)Total_A 3) Total_B. Total_A and Total_B are incrementing values so at 9 AM the value of Total_A might be 1000 and at 11 PM the value might be 1234 and so on... What I would like to...
  15. ideasworking

    schedule a print job?

    Hello, I would like to print a PHP webpage (on the local server) every night at midnight. Can anyone suggest a method to achieve this? Thanks, Lou
  16. ideasworking

    A little help with CSS please

    Hello, With the help of some people here I have managed to use CSS to format some tables such that some tables don't print and other tables print with borders that are collapsed. Now as I look at the code it appears that there are some mistakes. Would someone please review the code and help me...
  17. ideasworking

    MSSQL UDF and PHP

    Hello, I created a table valued function in MSSQL and now I would like to pull that data into PHP to display on the page. Is this possible? If so, how? This is what I have tried so far and it didn't work. $db = @mssql_connect("MSSQL","me","mypassword") or die("Unable to connect to server")...
  18. ideasworking

    Force table borders to print?

    Hello, Can someone help me with a CSS question? I would like to print a specific tables borders. Following suggestions from another question I changed my CSS to the following. <style type="text/css" media="print"> .noprint { display: none; } .borderprint {border-bottom:1px solid black...
  19. ideasworking

    prevent table from printing?

    Hello, I have created several web reports that I would like to print without the menu across the top of the page. I have placed the menu in a table... so I'm wondering if I can prevent printing of that table? If not... I'm wondering if I can use a button to print a similiar page that doesn't...
  20. ideasworking

    Help creating a trigger please

    Hello, I have never created a trigger before so... I'd like some help creating a trigger. I would like the trigger to do the following. When a new record is inserted into TABLE1 I would like to evaluate the inserted TABLE1.VALUE1 and if the inserted VALUE1 < 1 and UNITLOG.dbo.UNIT1.STATE = 'A'...

Part and Inventory Search

Back
Top