[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