in reply to Re: Explain SQL statement
in thread Explain SQL statement

For what it's worth, "this particular programmer" was only illustrating how the use of IN would change the code, not providing a complete, recommended solution.

The PerlMonk tr/// Advocate

Replies are listed 'Best First'.
Re^3: Explain SQL statement
by Anonymous Monk on May 26, 2004 at 15:31 UTC
    Could I try to place the values in alphabetic order after since I can't figure it out on the SQL query.
    Like to a SORT on the returned values from the "fetchrow_hashref"
    Do a SORT here in one of the returned values
    $comp=$pointer->{'comp_name'};
      It is certainly possible to accumulate all the rows returned in an array (of hashes), and then sort that array by whichever hash element you like before output.

      I still think what you really want to do is to have one query that returns all the data in the desired order.


      The PerlMonk tr/// Advocate