On 04/08/2013 07:44 PM, Hugues Max 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', {} );
my @allCommandeBNP= %allCommandeBNP; my $allCommandeBNP=@allCommandeBNP;
In my mysql table has 36 items and $allCommandeBNP egal 36
I use
if (params->{cmd} && params->{cmd} eq 'list') { return template 'template/navbar_login' => { username => params->{username}, password => params->{password}, tab => 3, ccmd => \%allCommandeBNP, show_list => "Liste des N° de commande:", }; }
and in my template
[% FOREACH s IN ccmd.keys.sort %] [% ccmd.$s.Ckey %]- [% END %]
the result is 18 items, one item on two and only even item
Liste des N° de commande: 210- 208- 206- 204- 202- 200- 198- 196- 194- 192- 190- 188- 186- 182- 184- 212- 214- 216-
On mysql.log with request log activated , request is SELECT * FROM `CommandeBNP`
if someone has a idea ?
You assign the database result to a hash instead of an array, so 18 records end up as hash keys and 18 records as hash values. Regards Racke -- LinuXia Systems => http://www.linuxia.de/ Expert Interchange Consulting and System Administration ICDEVGROUP => http://www.icdevgroup.org/ Interchange Development Team