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

    Database design help - product database

    thanks for the reply, I was just looking into that page before you posted it. I cant find anywhere on the web to enter product names and get the UPC codes? It may not exist?
  2. LGJ

    Database design help - product database

    Hello all, Please can anyone help me with designing a database schema that I am having some difficulties with? What I have is a load of products that are offered by different shops, like a price comparison website. What I have at present is one table with a row for each product with the...
  3. LGJ

    SQL - retrieving first entry for every user on a given day

    Thank you very much that is great. I have changed it slightly to also give a time range: select sum(event_price) from ( select event_price , row_number () over (partition by msisdn order by created_t) rn from ouk_revenue_loss_t where created_t > 1105605720 and...
  4. LGJ

    SQL - retrieving first entry for every user on a given day

    Hi, I need some help please on building an SQL query. Bear with me as I attempt to explain below: We have users attempting a purchase of a product, if they fail due to insufficient credit an entry is input in a DB table call rev_loss. Here is an example of a row in the table: created_t =...
  5. LGJ

    Weird hourly system time change?

    Thanks guys, (lol @ spamlys comment ;) )FYI : There is a known issue on Sun Fire 3800/4800/4810/6800, V1280, and Netra 1280 Domains where the time jumps usually by one hour. The problem is desbribed in Sun Alert 56680, which is available at...
  6. LGJ

    Weird hourly system time change?

    Hi, Just an update for anyone interested. Having contacted SUN, this was known to be a known fault with this hardware. A script was provided and applied successfully. The problem seems to take effect if the system controller has not been rebooted for 528 days Thanks to all involved for the...
  7. LGJ

    Weird hourly system time change?

    Hi, Just an update, /etc/inet/ntp.conf has been updated to point to different NTP servers also the drift reference in ntp.conf has been uncommented and a ntp.drift file has been created so that if connection is lost to the NTP server then time can be kept through this file. We are presently...
  8. LGJ

    Weird hourly system time change?

    Please find below some messages from /var/adm/messages. Are these normal? I have done a quick bit of research but do not have the experience of you guys to tell if this could cause system time changes? Once again thanks for your time on this, I only support the appication on this server and...
  9. LGJ

    Weird hourly system time change?

    We have the following in roots crontab: (could rtc be causing a problem?? - its not present in /usr/sbin/): #ident "@(#)root 1.20 01/11/06 SMI" # # The root crontab should be used to perform accounting data collection. # # The rtc command is run to adjust the real time clock if and...
  10. LGJ

    Weird hourly system time change?

    thanks again for all the replies - daFranze and spamly. We have the other teams involved in supporting the ntp servers looking into this. No luck so far unfortunately. Thanks LGJ
  11. LGJ

    Weird hourly system time change?

    thanks, looking into this now. (The workstation time is OK). We noticed the problem as we have log file rotations running from logadm. This runs from root crontab at 03:10 every morning. Unfortunately the rotations have been failing and we believe this is related, even though the system time...
  12. LGJ

    Weird hourly system time change?

    thanks for the reply. The output is shown below: pin:/var/portal/6.5/cm> ps -ef | grep ntp root 579 1 0 Jul 23 ? 0:01 /usr/lib/inet/xntpd could it be this xntpd? LGJ
  13. LGJ

    Weird hourly system time change?

    Hi all, Please can someone help, can anyone explain why the following might suddenly be happening on our Solaris box?: Thu Jan 6 11:59:52 GMT 2005 pin:/export/home/pin> date Thu Jan 6 11:59:54 GMT 2005 pin:/export/home/pin> date Thu Jan 6 10:59:56 GMT 2005 pin:/export/home/pin> date Thu Jan...
  14. LGJ

    excel - populating cells depending on value in other cells?

    Hi Glenn, Each product could have a value of say Name^Name Number and the number can be either 300, 250, 150, 500 for example. The number relates to pence I want to get the cost of each product (in pounds) if it has a number attached to the description so I can then total up that column. Is...
  15. LGJ

    excel - populating cells depending on value in other cells?

    Hi all, Please can someone help me or point me in the right direction? I have an excel sheet with example colum shown below: Ring^Standard 300 Image^Colour 150 Game^New 250 I need to create a formula which populates the cell next to it with the cost value (300 = 3 pounds, 150 = 1.50 ...) So...
  16. LGJ

    Back up files to different directory

    thanks guys, great help. Learning something every day. Cheers LGJ
  17. LGJ

    Back up files to different directory

    Hi all, Please can I get some help. I need to copy some files for back up purposes into another directory. All the files are called "pin.conf". I can do: ================ #!/usr/bin/ksh cd /opt/6.5/ for filen in `find . -name pin.conf` do echo ${filen} done ==================...
  18. LGJ

    Lots of update statements on table - best method?

    I have created a PRIMARY KEY on msisdn. Missed the unique index bit, it says its already indexed now! I get this now: where a.account_no=b.msisdn) * ERROR at line 3: ORA-01722: invalid number
  19. LGJ

    Lots of update statements on table - best method?

    hmmm, doing that I get this though? set o = n * ERROR at line 4: ORA-01779: cannot modify a column which maps to a non key-preserved table sorry for all the questions, I really appreciate the help. LGJ
  20. LGJ

    Lots of update statements on table - best method?

    I have tried this and get problems on the load, I am updating more than one field and my update looks like: update (select a.account_no, b.bdom n, a.actg_cycle_dom o, b.actg_next_t p, a.actg_next_t q, b.actg_future_t r, a.actg_future_t s from account_t a, account_stg b where...

Part and Inventory Search

Back
Top