Re: Add: Re: Re: UPD: output table with variable data

2003-02-22 Thread Angus Lees
At Fri, 21 Feb 2003 12:59:13 +0100, Alexander Hartmaier wrote: > Because I use a hash instead of an array now I've got the problem that sorting > with an ORDER BY sql statement is useless ;_((( > > I don't want to loose the pros of using a hash (i can reference an the columns > per name and if I a

Re: Add: Re: Re: UPD: output table with variable data

2003-02-21 Thread Ed Grimm
I use the second array idea, except that I store that array in the hash, under a key that will never be a real key. In my case, all of my legitimate keys are lowercase (the database has case-insensitive keys, and I simulate this in the import by lowercasing the keys), and my array of keys (with or

Add: Re: Re: UPD: output table with variable data

2003-02-21 Thread Alexander Hartmaier
Hi! Because I use a hash instead of an array now I've got the problem that sorting with an ORDER BY sql statement is useless ;_((( I don't want to loose the pros of using a hash (i can reference an the columns per name and if I add a new one don't need to touch the others). Hast anybody an idea

Re: Re: UPD: output table with variable data

2003-02-21 Thread Alexander Hartmaier
Hi! Thanks a lot gus! I've rewritten the whole thing yesterday to use a hash instead of an array. Know I use this statement to get my hashref: $ref_interfacelist = $dbh->selectall_hashref($sth, 'ID_INTERFACE'); Later I call the following: [- interface_list ($ref_interfacelist) -] And