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

  1. SatanClaus

    Problem with Date Format conversion HTML_DB APEX

    @Dagon: you don't need a co-worker? I hope your at least overpayed when underused! btw: Your last suggestion is what i was looking for. Gonna implement it now and re-write the other PL/SQL blocks i did wrong... Until then: thank you Dagon and Hoinz! This Problem is solved. Maybe i come back...
  2. SatanClaus

    Problem with Date Format conversion HTML_DB APEX

    and again faster... Don't you have to work? ;-) Just joking!
  3. SatanClaus

    Problem with Date Format conversion HTML_DB APEX

    @Dagon: Ohh, you were was faster then me! ;-( I will take a look at your suggestion and then reply later. so much to do besides programming in this (nearly-)one-man-it-department, that an answer lasts half an hour to write/submit ;-) cu
  4. SatanClaus

    Problem with Date Format conversion HTML_DB APEX

    Hello dagon, hello hoinz, thank you for your fast reply! I think you convinced me of the trunc function. But i don't get the right effect. when i use TRUNC(TO_DATE(:P18_TERMVON, 'DD/MM/YYYY HH24:MI')) i get 25.09.2006 but when i combine this truncated date with a substr of a varchar...
  5. SatanClaus

    Problem with Date Format conversion HTML_DB APEX

    Hello and good morning all together! We are running an oracle 10g DB with Application Express (APEX, formerly HTMLdb). I'm trying to create a little PL/SQL block that writes a sequence of dates into a table. In this PL/SQL block i have an user variable :P18_TERMVON the input for this variable...
  6. SatanClaus

    Selecting same column with different where's

    Hi Solo, if i did get you right, this could be what you're looking for: SELECT JCJOBCAT.JCAT_PHS_CODE, JCJOBHPHS.JHP_NAME, sum(jc_o.jcdt_amt) o_sum, sum(jc_c.jcdt_amt) c_sum, SUM(DISTINCT JCJOBCAT.JCAT_BUDG_AMT) AS EXPR1, SUM(JCDETAIL.JCDT_AMT) AS EXPR2 FROM...
  7. SatanClaus

    W2K-machines only admits low res, otherwise crashes!!!! HELP!

    Thank you all... Installed SP2, installed correct drivers, uninstalled card, reinstalled card, --> The machines run like hell.... Yeah Greetz from Germany, till next time....
  8. SatanClaus

    W2K-machines only admits low res, otherwise crashes!!!! HELP!

    Hi Jennifer Nope. Installed W2K pro and after that i installed SP3! But thx for that suggestion, will try it! SatanClaus (also 1/2 of the IT Staff ;-))
  9. SatanClaus

    W2K-machines only admits low res, otherwise crashes!!!! HELP!

    Hi wolluf, I will look into the event viewer, and yes uninstalled the display adapter and let it reinstall by windows. Another hint: i put a pci display adapter in, and it worked. But this can´t be the solution: To replace a proper working display adapter with a proper working display adapter...
  10. SatanClaus

    W2K-machines only admits low res, otherwise crashes!!!! HELP!

    @rathcoffey: Have the latest drivers installed (hope so)! @wolluff: yeah, i open display properties, and the moment i click the setting tab, the system crashes. Not earlier, not later! And that´s with three machines! So, anyone knows? thx, SatanClaus P.S.: I´m sorry about my disguisting english.
  11. SatanClaus

    W2K-machines only admits low res, otherwise crashes!!!! HELP!

    We are installing W2K on all PCs in our company. (About 40 machines). Now we have huge problems with some machines (all nearly the same conf.): Celeron 333 up to P2 400, all ATI Rage Pro onboard, 64 up to 128 MB RAM Prob: After install(W2k/SP3/Novell Client/NovellSP and so on, all configured...

Part and Inventory Search

Back
Top