Re: sorting hash list for CGI Form

2004-03-09 Thread R. Joseph Newton
Scott Taylor wrote: > Hello all, > > When I populate this hash (%SrcIDs) from "SELECT id, desc, from myTable > order by desc" it What does "it" refer to here? If you mean the SQL engine, which does care about the content of order clauses, you are mistaken. Your data set is returned in the prope

Re: sorting hash list for CGI Form

2004-03-09 Thread James Edward Gray II
On Mar 9, 2004, at 3:39 PM, Scott Taylor wrote: Hello all, Howdy. When I populate this hash (%SrcIDs) from "SELECT id, desc, from myTable order by desc" it doesn't order by the description field "desc". (printing each row in the while loop show that the SQL is sorted) See inlined change bel

sorting hash list for CGI Form

2004-03-09 Thread Scott Taylor
Hello all, When I populate this hash (%SrcIDs) from "SELECT id, desc, from myTable order by desc" it doesn't order by the description field "desc". (printing each row in the while loop show that the SQL is sorted) while( my($id, $desc) = $sth->fetchrow ) { $SrcIDs{$id} = $desc; } $sth-