[dancer-users] Complex Query ?

Hugues hugues at max4mail.com
Tue Jan 28 08:34:02 GMT 2014


Hello
I use dancer 1 with with mysql

@resultCC  = database('db')->quick_select('ClientContrat', { NumContrat 
=> { like => "$search%" } }, { limit => 10 } );

I send @resultCC to my template tt and it's work well

I would like to pass complex query

  my $sql ="SELECT Client.CodeClient, Client.NomClient,Client.Ville, 
ClientContrat.NumContrat FROM Client INNER JOIN  ClientContrat
                                   ON (Client.CodeClient = 
ClientContrat.CodeClient)
                                   WHERE Client.CodeClient LIKE '%" 
.$search. "%' LIMIT 10";

I do not find solution to use current mysql connection , and 
quick_select ?  ( it 's ok only if I create new connection with , 
connect, prepare execute ....)
what is the best way to do that ?
thanks
Hugues.






More information about the dancer-users mailing list