Thanks you, very much,  It's works

but I not really understand why with hash , half of result go to keys and other to values and how template toolkit do the relation between database fiels and values with simple list ?

for my point of view , a simple "complet" example will be good idea in documentation.
complet = perl part AND ttk part

bye
Hugues


Le 08/04/2013 21:25, David Precious a écrit :
On Mon, 08 Apr 2013 19:44:24 +0200
Hugues Max <[email protected]> wrote:

Hello
I've got stange problem with dancer with twitter boostrap
I use

use Dancer::Plugin::Database;
my $dbh = database({driver => 'mysql', database => 'asav'});
   my %allCommandeBNP = database->quick_select('CommandeBNP', {} );
The docs[0] say of quick_select:

  returns either the first matching row as a hashref if called in scalar
  context, or a list of matching rows as hashrefs if called in list
  context

You're assigning that to a hash; that implies list context, so your
hash will have both keys and values representing rows.

e.g. you'll end up with a hash looking like:

   (
       'HASH(0x5356)' => \%row1,
       'HASH(0x5367)' => \%row2,
   )

etc.

You want to assign straight to a list:

   my @allCommandeBNP = database->quick_select('CommandeBNP', {} );

Then pass that straight to your template, e.g.

   ccmd => \@allCommandeBNP,

And in your template, just iterate over that.


[0] https://metacpan.org/module/Dancer::Plugin::Database::Handle




_______________________________________________
dancer-users mailing list
[email protected]
http://lists.preshweb.co.uk/mailman/listinfo/dancer-users

Reply via email to