Re: [Templates] hashes and loops

> Brandon Hall wrote:

Michael wrote:
> Brandon Hall wrote:
> 
>> On Tue, 19 Oct 2004 12:10:20 -0700, Sean Kellogg
>> That solved it magnificently! Now i'm trying to clean it up so I don't
>> have to specify the fields and I can cut and paste more code ...so. I
>> wrote this using what I've learned. This snip works, but I don't think
>> it's correct. I think there is a perl fudge making it work ;)
>>
>>    while (my $rowref = $sth->fetchrow_hashref) {
>>        foreach (my $href = $rowref) {
>>            my %result = %{ $href };               push @notes, \%result;
>>        }
>>    }
> 
> 
> this would be better written as...
>     my $notes = $sth->fetchrow_arrayref({});
> 

I meant...
     my $notes = $sth->fetchall_arrayref({});

sorry!

> This will put each row as a hash ref inside of one array ref that you 
> can then pass to your template. Much cleaner.
> 
>>
>> This way, in the template I can just use the database fields. eg,
>> timestamp, id, param1, etc.
>> -- 
>>
>> _______________________________________________
>> templates mailing list
>> templates@xxxxxxxxxxxxxxxx.xxx
>> http://lists.template-toolkit.org/mailman/listinfo/templates
> 
> 

        -- 
        Michael Peters
Developer
Plus Three, LP

_______________________________________________
templates mailing list
templates@xxxxxxxxxxxxxxxx.xxx
http://lists.template-toolkit.org/mailman/listinfo/templates