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.
_______________________________________________
dancer-users mailing list
[email protected]
http://lists.preshweb.co.uk/mailman/listinfo/dancer-users
