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 Rhinorhino 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: *

  1. memarkiam

    SQL Loader Error - Commit point reached - logical record ..

    I have the same problem. But it's after 64 records. My import file has 42k rows. But it doesn't keep going. It just stops and returns me to the command line prompt. Any ideas? Thanks! Mark
  2. memarkiam

    Websphere Referer logs problem

    No, sorry. I finnaly gave up, I'm afraid to say. Best of luck! Mark
  3. memarkiam

    ORA-01476: divisor is equal to zero

    ...> 24 then '25_' END as Span, CUSTOMER_LIFETIME_TOTALS.OCCURRENCE_1_TRANSACTION_DATE as Rcncy, CASE WHEN TRUNC(30*MONTHS_BETWEEN(SYSDATE, CUSTOMER_LIFETIME_TOTALS.OCCURRENCE_1_TRANSACTION_DATE),0) <= 30 then 'Last Month' WHEN TRUNC(30*MONTHS_BETWEEN(SYSDATE...
  4. memarkiam

    ORA-01476: divisor is equal to zero

    I'm getting the above error in a query. How can I 'trap' this error, and basically ignore it? Many thanks, Mark
  5. memarkiam

    Dynamic Worksheet names in cells

    Thanks! That's great - it hits the spot perfectly! Don't know how I missed that in the help file... If I can be cheeky and ask a follow on question: In the Macro I'm writing to go along with this sheet, I need to access data in several workbooks. I planned to do this by using: Dim R1 As Range...
  6. memarkiam

    Dynamic Worksheet names in cells

    Hi - I need to be able to change the name of the Worksheet, ideally by reference to the content of another cell. EG: =SUMIF([atvwk15.xls]storerep!$B$2:$B$201,$A$2,[atvwk15.xls]storerep!$D$2:$D$201)/SUMIF([atvwk15.xls]storerep!$B$2:$B$201,$A$2,[atvwk15.xls]storerep!$C$2:$C$201) In the above...
  7. memarkiam

    Multiple IP set-ups

    Thanks for this. It's interesting. But I don't think it solves my problem. I did try it, but one of my required settings is &quot;Obtain IP/DNS Automatically&quot;, and selecting this just deleted all the IP entries I set up through the 'add IP address' interface. Thanks anyway. Cheers, Mark
  8. memarkiam

    Multiple IP set-ups

    I have to plug my laptop into various different client offices. Each one requires a different set of IP/Router/DNS settings. At the moment I manually change them each time. What a bore! Can I store muptiple IP settings, and switch between them on the fly? Many thanks for any help. Mark Lewis...
  9. memarkiam

    Websphere Referer logs problem

    I have a problem. My web developer insists that their Websphere v3.5 can only produce referer logs seperate to the main web logs. In my (limited!) experiance, a web log is typically: User IP| Date/time| GET statement| refering page/key words The seperate referer logs I am getting from...
  10. memarkiam

    Using Terminal Services via a Mac

    I need to access a Windows system via Terminal services from an office of Mac's It seems you can get software to do this for OS-X, but these Mac's are all on OS-9. I can't find any TS software for OS-9. Does anyone know how this can be done? Many thanks, Mark
  11. memarkiam

    Using DECODE to avoide DIV by zero errors

    I'm having trouble with DIV/0 errors. I can't filter this out in the HAVING clause as the whole role row will go, and there is data in other columns I need. Someone suggested using DECODE, which seemed a good idea, but I can't get the syntax right for this query. The particular statement that...
  12. memarkiam

    Using Column aliases in calculations

    ...as Starters, count(case when DM2_EMPLOYEE.DATE_OF_TERM >='1-Jan-2001' then DM2_EMPLOYEE.DATE_OF_TERM end) as Leavers, Leavers/HeadCount * 100 as Churn, avg(case when DM2_EMPLOYEE.DATE_OF_TERM >='1-Jan-2001' then trunc(months_between(DM2_EMPLOYEE.DATE_OF_TERM...
  13. memarkiam

    Using Column aliases in Calculations

    ...as Starters, count(case when DM2_EMPLOYEE.DATE_OF_TERM >='1-Jan-2001' then DM2_EMPLOYEE.DATE_OF_TERM end) as Leavers, Leavers/HeadCount * 100 as Churn, avg(case when DM2_EMPLOYEE.DATE_OF_TERM >='1-Jan-2001' then trunc(months_between(DM2_EMPLOYEE.DATE_OF_TERM...
  14. memarkiam

    Problem Loggin in Domain/Workgroup - Help!!!!

    I managed to sort out most of my porblems in the end. Initially, I tried every admin apssword I thought might be relevent - but to no avail. Finnaly, I tried Administrator with the password from my personal user account - it worked! I have no explanation for this. This has given me full admin...
  15. memarkiam

    Problem Loggin in Domain/Workgroup - Help!!!!

    Thanks for this. I'm away for 2 weeks now. I'll try on my return. Cheers! Mark
  16. memarkiam

    Problem Loggin in Domain/Workgroup - Help!!!!

    My 'Other user' is definatley a domain user. When you say 'joined to that domain' I take it you mean physically connected to (or dialled into) that domain's server? If I can set this up, will my laptop detect that I am connected to this domain, and accept my domain user/password? If so, this...
  17. memarkiam

    Problem Loggin in Domain/Workgroup - Help!!!!

    Well, It looks like I'm done for! The new user that was created for me (why? should have been same user, different config...) doesn't have Admin rights. Isn't there a way to log back in as my other user? It should still be there I presume, I just don't how to access it. I suppose if I...
  18. memarkiam

    Problem Loggin in Domain/Workgroup - Help!!!!

    Thank you both for your replies. I'm using Win2k Proffesional. No, I don't need to log back into the office network (I've left that company - bought the laptop), its just my user on that domain (locally on my laptop) has all my files/configurations/authorities, which I relly need to get back...
  19. memarkiam

    Problem Loggin in Domain/Workgroup - Help!!!!

    I was trying to set up a peer-to-peer to share files at home last night, and changed my Network Indentity from a domain to a Workgroup (which is what Help said I needed to do). This didn't help me to share the files, but has completely messed up my laptop by creating a new user and locking me...
  20. memarkiam

    Weird error mesages from query

    Thanks for the lead! I'll go and check this now. Cheers!! Mark

Part and Inventory Search

Back
Top