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 gkittelson 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. masalachol

    weblogioc.jdbc.db2.DB2Driver

    I have weblogic 8.1 and When trying to create a connection pool to db2 on z\os. I get the following message : "The selected database driver is not installed in the classpath. You must install the driver to create a working connection pool". So I need help on the following: 1. Where can I go...
  2. masalachol

    Removing comma's within quatation marks

    Hello: I am bringing this up again since we have gotten a little further and my previous comments and thus looking for some urgent input. Well I have a csv file where some strings are enclosed by a quotation marks. We found that the following sed operation sed 's/\(".*\)[,]\(.*"\)/\1\2/g'...
  3. masalachol

    sed command

    I have a file where I have to remove the commas that are between quotation marks and then replace the quatation marks with a pipe |. ie so far I have sed 's/\("*[,]*"\)/\|/g' and this replaces the quotation marks with a | but I feel I am going about it the wrong way. Any suggestions? file...
  4. masalachol

    SQL%ROWCOUNT

    ok thank you very much .... i figured it out.
  5. masalachol

    SQL%ROWCOUNT

    Ok i did what you suggested and it worked ... 1 2 PL/SQL procedure successfully completed. ok now I only want to capture the total number which would be 2 ....how do I do that?
  6. masalachol

    SQL%ROWCOUNT

    I have multiple inserts and would like to know the total insert per job.....below with sql%rowcount I am only getting a count per insert not the total. Any suggestions? CREATE OR REPLACE PACKAGE BODY dbcarrier_load_data_pkg IS PROCEDURE invoice_load_pp (p_orgid IN cc_invoice.org_id%TYPE...
  7. masalachol

    If statement with within query

    Golom and PHV .... YOU ARE AWSOME, THANKS!!!
  8. masalachol

    If statement with within query

    I am trying to do the following in a query without success. Any suggestions If ParseOne+ParseTwo-Imp3=-0.01 then 0.01+ParseTwo Else ParseTwo OR If ParseOne+ParseTwo-Imp3=0.01 then ParseTwo-0.01 Else ParseTwo P2...
  9. masalachol

    GUI Interface for MySQL

    To me the best one in the market is navicat
  10. masalachol

    Mysql and suse linux 9.1 personal edition

    Does anyone in this forum use mysql on a suse linux personal edition 9.1? If you do what mirror did you use to dowload mysql version 4.0. Also any linux pc user that has mysql I would sure appreciate some insight as your experience downloading and starting mysql on linux....any do's and don't do.
  11. masalachol

    Can't start MySql server 4.0 after a couple of days?

    I am new and had similar problems with 5.0 and decided to go back to 3.23 and have not had any issues.
  12. masalachol

    getting started (/me is newbie)

    I am new at this also... there seems to be a couple of ways to do it. First I believe that if you are in a windows environment you can go to the c:\window directory and you will find a my.ini file. When you restart your computer this file will be read and the database will mount... you will see...
  13. masalachol

    Load Log

    Hello: I am new to MYSQL and my knowlege base is from reading online documentatation. I found that the quickest and most convinient manner to load data to existing tables is using the load data infile <filename> into table <table_name> fields terminated by ' ' lines terminated by ' ' My...
  14. masalachol

    Mail List

    Thanks, It works great!!!
  15. masalachol

    Mail List

    hello: I am in a UNIX environment and I have a file named "mailout" that I am reading with the program below.What I really want to do is mail the report to my email address without echoing it to my screen. Looking forward to your replies...
  16. masalachol

    query

    GREAT suggestions!! and the Mid(BRANCH, InStr(BRANCH, "/") + 1) and SELECT MID(Branch_Number, 8) worked!! =======
  17. masalachol

    query

    In a table I have a column called Branch_Number and it looks like the example below. ie: Branch_Number 1111111/2222222 3333333/5555555 Using a query I would like to just capture the values right of the "/" forward slash character {2222222,5555555 from the Branch_Number column . Any suggestions?
  18. masalachol

    Enable

    mndrlion....Thanks for all your help!!! :) Milenko
  19. masalachol

    Enable

    Thanks for your reply and sorry that I have taken long on the response. Private Sub Tracked_Enter() If Branch = 3000004 Then Tracked.Enabled = True Else Tracked.Enabled = False End If End Sub I am trying your suggestion by right clikcing on the check box field "Tracked" thus going...
  20. masalachol

    Enable

    Hello: What would be your suggestions on the following: fielda filedb fieldc checkbox 111111 222222 333333 How would you go about writing a simple event that would do the following on the above fields that are on a form. If fieldc = 3333333 then disable the checkbox else enable...

Part and Inventory Search

Back
Top