select multiple bug ?

[Buzz]

Hi,

I've just discover DaDaBIK, and it looks pretty cool Great job !
I've a little problem with select_multiple_menu/checkbox :
In the search form, when I select multiple choices, it return nothing ! (I've inserted the values with DaDaBIK).
It only works with a single choice.

Exemple :
select * from `test_tab` where `field04` like '%~option1~%' and `field04` like '%~option2~%' limit 0 , 20
--> No results.
But with single check :
select * from `test_tab` where `field04` like '%~option1~%' limit 0 , 20
--> working fine.

Is it me or a bug ?
thx for your help

 

[Buzz]

anyone ?

 

[Eugenio]

Buzz wrote:
>
> Hi,
>
> I've just discover DaDaBIK, and it looks pretty cool Great
> job !
> I've a little problem with select_multiple_menu/checkbox :
> In the search form, when I select multiple choices, it return
> nothing ! (I've inserted the values with DaDaBIK).
> It only works with a single choice.
>
> Exemple :
> select * from `test_tab` where `field04` like '%~option1~%'
> and `field04` like '%~option2~%' limit 0 , 20
> --> No results.

Hi,
as you can see from the query, DaDaBIK uses the AND operator to link the options you have choiced. Probably you don't have any field4 that contains both option1 and option2.

Eugenio.

(Latest version of DaDaBIK when this message was posted: 2.2.1)