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 IamaSherpa 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. MikeLee

    CMP muitple primary key~

    I try my best to make the EJB work, here is my code, pls help~ i am using jboss-3.0.0_tomcat-4.0.3 standardjaws.xml <enterprise-beans> <entity> <ejb-name>ShippingScheduleEJB</ejb-name> <table-name>ShippingSchedule</table-name> <pk-constraint>true</pk-constraint> <cmp-field>...
  2. MikeLee

    SQL query problem

    I have some problem about my query, I wonder how can i find result that only exist on table 1, but not table 2 table 1 - {card_no, other_data} table 2 - {card_no, other_data2} let say table 1 have record {1, data1}, {2, data2}, {3,data3} table 2 have record {1, dataa}, {3, datac} ,{4, datad} i...
  3. MikeLee

    SQL QUERY - JOIN

    Oh, i know, MySQL does have Union after MySQL v4.0 but i am using MySQL 3.23.49,
  4. MikeLee

    SQL QUERY - JOIN

    yes, i also think of this solution, but i would also like to make it in one table which is order by date, i try to use union, but fail..
  5. MikeLee

    SQL QUERY - JOIN

    thanks for your reply~ let say table 1 have record staff_id date other field 1 2002-08-10 .... 1 2002-08-13 .... table 2 have record staff_id date remark 1 2002-08-10 remark1 1 2002-08-12 remark2 i would like to have...
  6. MikeLee

    SQL QUERY - JOIN

    AS I know, MYSQL don't support full outer join so i have some problem for my query, I have 2 table table 1 { id date other infomation.... } table 2 { id date remark } now i need to show a table something like other join, show the record once it exist on each table or...
  7. MikeLee

    QUESTION ABOUT MYSQL CLIENT!

    Oh, i know what's wrong with my setting now, I havn't grant the user right correctly, thx a lot
  8. MikeLee

    QUESTION ABOUT MYSQL CLIENT!

    i have already add the port in the ipchains and restart it
  9. MikeLee

    QUESTION ABOUT MYSQL CLIENT!

    I have install mysql using Redhat 7.3, I can run it locally, but if I want to connect from remote, it can't connect, what I need to set? am i need to add services to xinetd.d? what is the details of adding services?
  10. MikeLee

    Update JSP from WebSphere

    I add the project containing JSP to the enterprise services, Can I just update the JSP by changing the content inside the installedApp, I try it and It seems it is not work, then is it mean that I need to update the JSP and make the war file and then import it again? Thanks

Part and Inventory Search

Back
Top