use Perl

• Dude (Score:1)

  by JeffK (3094)

  way to use the free software. Oracle's nice, but the cost is so prohibitive for the little guy. I might have some search scripts laying around if you wanna look at it.
  
  JeffK
  
  What was that other guys problem? You run into those jerks everywhere.
  • Re:Dude (Score:1)

    by gizmo_mathboy (782)

    I'm running Apache and RedHat 7.2,too.
    
    I'm currently looking at Tomcat to see if a java servlet can run on it. I might have to use win2k for that since the company that created the servlet (and assoicated apps) is windows only. I would like to stay on Linux/Apache but I may have to move to win2k/Apache. I hope I won't have to go win2k/IIS.
    
    I think the biggest problem with the search script is that I'm potentially querying 2 tables. With no subqueries I had to make 2 queries and then merge them. Not that big
    • Try this (Score:1)

      by JeffK (3094) <JeffKguru@hotmail.com> on 2002.05.01 15:23 (#7815)

      Here are different examples of how to do a psudeo-subquery with MySQL.
      
      # max_salary table to get the names of the
      # employees with the highest salary.
      #
      SELECT employee_name
      FROM employee, salary, max_salary
      WHERE employee.employee_id = salary.employee_id
      
      AND salary = max_salary
      ---------------------------------------------------------------
      
      SELECT employee_name
      FROM employee, salary
      WHERE employee.employee_id = salary.employee_id
      AND salary = (SELECT MAX(salary.salary) FROM
      salary);
      
      ----------------------------------------------------------------
      
      SELECT @salary:=MAX(salary.salary) FROM salary;
      UPDATE salary SET salary = salary * .75 WHERE
      salary = @salary;
      
      You have to work around the IN.
      
      I'm not really great at perl yet. But hopefully
      you will be able to make use of
      the SQL
      
      Good luck
      JeffK

      Reply to This

      Parent

      • Re:Try this (Score:1)

        by gizmo_mathboy (782)

        Cool. Perl runs strong in me but SQL is weak. Maybe I can trade Perl knowledge for SQL. ;-)
        
        Know of any good SQL books? I suppose I should poke around the usenet archives, but I'm lazy and like to get recommendations before I spend money on an area I'm not so knowledgeable.