Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • 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.
    • 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
      • 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
        • 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.