Love Fuel?    Donate

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.
Error on "Call procedure"
  • Hello ! i have an error on my db query, i try to call a sql procedure, but DB::query('CALL getLists(27);')->execute(); return just the count of the result.. !
    If i try a normal query, like select, print_r return a normal response. And my procedure works fine in phpmyadmin. Where is the mistake?
  • Ok, i found me response in http://fuelphp.com/forums/topics/view/4299 Sorry.
    But the solution is strange !
  • Different types of queries are handled by different DB drivers, based on the type of query. But there is no driver for queries of type "CALL". So you have to force the query to be handled by the "SELECT" driver by specifying the driver in the call.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion