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 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: evr72
  • Order by date
  1. evr72

    Update field from one table with a join table

    Just in case anybody sees this, I figured it out, not pretty but it works UPDATE AMFLIB2.CUSMAS T3 SET T3.ACREC = 'S' WHERE T3.ACREC IN ('A') AND EXISTS (...
  2. evr72

    Update field from one table with a join table

    Hello, I am trying to update a field, I have two join tables. I have tried a few things but keep on getting various errors two tables AMFLIB2.CUSMAS AND AMFLIB2.MBEKRES2 the field I want to update is in AMFLIB2.CUSMAS.ACREC the where statement uses the field EKCJNB from table AMFLIB2.MBEKRES2...
  3. evr72

    Get last field value into next row

    Is that the issue?
  4. evr72

    Get last field value into next row

    I used this to exclude Saturday and Sunday. I know I could have made it easier :) WHERE (CASE WHEN DAY ='SATURDAY' THEN 1 WHEN DAY = 'SUNDAY' THEN 1 ELSE 0 END <>1)
  5. evr72

    Get last field value into next row

    I use that to exclude Saturday and Sunday
  6. evr72

    Get last field value into next row

    Hello, Is there a way to get the last value in a column into the next row My table looks like this Day Begin Invoice Cash Change Ending 1 7500 2500 500 2000 [highlight #FCE94F]7000[/highlight] 2 [highlight #FCE94F]7000[/highlight]...
  7. evr72

    Wundows Server 2003 DNS can resolve names but not ip addresses

    Hello, I have a windows 2003 server, it can resolve \\myserver\myfolder but when I try the ip address \\192.168.2.25\myfolder it cannot find the ip I can ping the server. never seen anything like this before Any help advice, I s much appreciated EV
  8. evr72

    DB2 SQL View Editable Fields

    Hello, I am a bit new at this one. I have a table for orders, each order has a unique number lets call it "UORD" I create a view with just the "UORD" field, is there a way to create a view and add fields to the view that can be edited? I tried the example below but it did not work, I got a...
  9. evr72

    Nothing happens creating a new ODBC DSN for iSeries

    Got the user working. When the user was given his laptop the wrong drivers were installed for IBM iSeries Client Access. Installed new drivers and fixed the issue.
  10. evr72

    Nothing happens creating a new ODBC DSN for iSeries

    Hello, I hope this is the correct place to post this. I have setup numerous odbc dsn connections, this morning, when helping out a colleague, using Windows 10 opened the ODBC admin window, clicked on add, select the ODBC Driver 32bit for iSeries, click on Finish and nothing happens, I usually...
  11. evr72

    Can addition or sustraction be performemed on two case statments

    Hello, I have a report that get the data from sql statements, it is looks something like this SELECT I9ADR7, CUSNM, SUM((case when yr = YEAR( CURRENT DATE)-4 then sales end)) AS "2013", SUM((case when yr = YEAR( CURRENT DATE)-3 then sales end)) AS "2014", SUM((case when yr = YEAR( CURRENT...
  12. evr72

    zip code by range with two tables

    Hello, I have two tables, one that contains all the U.S. zip codes, city and state and a second table that contains 3 fields zip codemin, zip codemax, renumber I would like to get the rep number to the zip codes table. but not sure how to go about it. if I try to join the zip code it will only...
  13. evr72

    multiple devices multiple networks best practices help

    Hello, I am new at this sort of stuff, i am helping out a friend to improve his network, he owns a restaurant, he often has issues with the not being able to access the internet, he also offers free wifi ant any point upto 150 people can be connected to the internet, he does not have any...
  14. evr72

    Time Difference Calculantion

    vacunita, sorry for the slow reply, thank you!!! that worked!!!
  15. evr72

    Time Difference Calculantion

    vacunita, for some reason the code did not work I had some issues because the time being capturd is based on 24 hr I found the code below and it works well, the only issue I have is that it gives me a whole number Time in: 5:58 AM Time Out: 9:00 AM With the code below this is what I get...
  16. evr72

    Time Difference Calculantion

    Hello, I am very new to programming and PHP, I have 3 fields "TIMIN" captures the log in time "TIMOUT" captures the time out and "TOTTIME" is supposed to get the difference of "TIMIN" - "TIMOUT" the way the time fields were created is a bit restricting they are only 6 digits so I have to get...
  17. evr72

    time stamp

    Hello, I am building a log in and out to track the time each employee spends on a specific job. I can capture their time in and time out with no issues, but to calculate the total time is where I am a bit confused. my script is very simple, I simply to capture the time in the employee scans...
  18. evr72

    on enter move to next field

    ChrisHirst, I saw where my mistake was. I appreciate you spending the time to look at it else I would never have noticed it. again thanks, EV
  19. evr72

    on enter move to next field

    Hello, I have a form that has two numeric fields, when the form loads the fields appear with a 0 I was able to get rid of this. I was trying to add to my script that when the enter key is pressed the cursor clears the 0 and goes to the next field but looks like something is a miss and have...
  20. evr72

    Execute JavaScript when page loads

    ChrisHirst, thank you, I tried all of them but none seem to work. I really appreciate the guidance.

Part and Inventory Search

Back
Top