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 Chris Miller 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: gary1975
  • Order by date
  1. gary1975

    Access functionj from new window

    Hi No it hasn't, that might be the problem then. The error I get is 'Object doesn't support this property or method' Thanks again Gary
  2. gary1975

    Access functionj from new window

    Hi Yes the function is in the popup window Thanks Gary
  3. gary1975

    Access functionj from new window

    Hi I am trying to access a function from a window I open, The code is below. var thewin = window.open('../index.asp', "oldwin"); thewin.thetest(); But I can't seem to get it to access the function thetest() Any Ideas? Thanks Gary
  4. gary1975

    Copying data between tables

    I managed to work it out I used this template: UPDATE #t1 SET #t1.c2 = #t2.c2, #t1.c3 = #t2.c3, #t1.c4 = #t2.c4 FROM #t2 WHERE #t1.c1 = #t2.c1 Thanks Gary
  5. gary1975

    Copying data between tables

    Hi Thanks for the reponse. I basically want to update rows from db1 to db2 that are related e.g. db1: FID Actual_Tonnes_Road_2000 Actual_Tonnes_Sea_2000 31 8000 6000 32 7890 9809 33 7777...
  6. gary1975

    Copying data between tables

    Hi I have 2 databases with similar tables e.g. [Forestry].[dbo].[ORIGIN_POINTS] (db1) FID Actual_Tonnes_Road_2000 Actual_Tonnes_Sea_2000 [SDE_Forestry].[dbo].[SEFE_ORIGINS] (db2) ID telNum Actual_Tonnes_Road_2000 Actual_Tonnes_Sea_2000 The problem that I have is that I want to get...
  7. gary1975

    SQL Sum

    Thank you
  8. gary1975

    SQL Sum

    Hi I am trying to add a few coloums, but I continually get the answer of zero. I think it is happening because all the coloums I am using are integers. This is my formula which is part of a sql statement: ((Sum(york1.T20C156) + Sum(york1.T20C157)) / (Sum(york1.T20C155)))*100 AS varOwnerOcc...

Part and Inventory Search

Back
Top