[ingo] Multiple vacation_unset

[woj woj]

2014-02-19 14:25 GMT+01:00 Jan Schneider <jan at horde.org>:

>
> Zitat von woj woj <wojnas at gmail.com>:
>
>
>  Hello.
>> could anybody knows how to make two queries for vacation_unset script in
>> ingo?
>> In mysql php driver works semicolon ; like this
>> 'vacation_unset' => 'UPDATE vacation SET active = 0 WHERE email = %u ;
>>  DELETE from vacation_notification WHERE on_vacation = %u',
>> But when I change php driver to mysqli a got syntax error.
>>
>
> This is not supported. You may use a stored procedure instead.
> --
> Jan Schneider
> The Horde Project
> http://www.horde.org/
> https://www.facebook.com/hordeproject
>
> --
> ingo mailing list
> Frequently Asked Questions: http://wiki.horde.org/FAQ
> To unsubscribe, mail: ingo-unsubscribe at lists.horde.org


Thanks for information Jan.
I created stored procedure on mysql database, and induced by following
function.
CALL vacations_on(%u,%s,%m)