| # |
Oct 8th 2018, 18:34 |
 beakman |
I know, I was building on top of your suggestion of using `IN`. |
| # |
Oct 8th 2018, 18:33 |
edgaras.jan |
you can't ``` 'OR' => [ 'DATE(specific_date)' => '2018-10-24', 'DATE(specific_date)' => '2018-10-24', ] ``` |
| # |
Oct 8th 2018, 18:32 |
edgaras.jan |
yes, only there is problem when you need same field (array key), then you need use subarray |
| # |
Oct 8th 2018, 18:30 |
beakman |
I think the `'OR' => [...]` part is what he was looking for. |
| # |
Oct 8th 2018, 18:29 |
beakman |
``` 'OR' => [ ['DATE(specific_date) IN ' => '2018-10-24', '2018-10-25], ['DATE(specific_date)' => '2018-10-24'], ['DATE(specific_date)' => '2018-10-24'], 'week_day IN' => [1,4,3,6], ] ``` |
| # |
Oct 8th 2018, 18:28 |
edgaras.jan |
or if you wish first form ``` 'OR' => [ ['DATE(specific_date)' => '2018-10-24'], ['DATE(specific_date)' => '2018-10-24'], ['DATE(specific_date)' => '2018-10-24'], 'week_day IN' => [1,4,3,6], ] ``` |
| # |
Oct 8th 2018, 18:25 |
edgaras.jan |
`SELECT * from `seminars` where (DATE(specific_date) IN ('2018-10-24', '2018-10-25', '2018-10-29')) OR week_day IN (1,4,3,6)` |
| # |
Oct 8th 2018, 18:25 |
nk-sonu |
in dated we can use IN ? @edgaras.jan |
| # |
Oct 8th 2018, 18:25 |
nk-sonu |
i am confused in "OR" |
| # |
Oct 8th 2018, 18:24 |
edgaras.jan |
use `IN` |
| # |
Oct 8th 2018, 18:24 |
slackebot |
<nk-sonu> |
| # |
Oct 8th 2018, 18:21 |
nk-sonu |
hi. what to do if i want to search multiple dates compare in OR in mysql with same 1 field ? |
| # |
Oct 8th 2018, 18:14 |
developer |
Hi Guys. Hope all doing well. I was stuck in cakephp or condition. I want to use multiple OR condition with 3 different dates from same field. |
| # |
Oct 8th 2018, 16:46 |
ricksaccous |
actually i figured out the replace strat thing |
| # |
Oct 8th 2018, 16:42 |
rrd564 |
and I want to sort after the grouping |
| # |
Oct 8th 2018, 16:42 |
rrd564 |
The collection is after a groupBy |
| # |
Oct 8th 2018, 16:41 |
rrd564 |
Is there a way to sort a collection by the index of its items? Something lige ksort for arrays? |
| # |
Oct 8th 2018, 15:07 |
ricksaccous |
some of them require looking at matching data on other models |
| # |
Oct 8th 2018, 15:07 |
ricksaccous |
because i only want deletions in the replace based on certain conditions |
| # |
Oct 8th 2018, 15:07 |
ricksaccous |
because while i do want some replace-like behavior sometimes on this project there always seems to be some quirk to it |
| # |
Oct 8th 2018, 15:06 |
ricksaccous |
I'd love for a more robust replace strategy |
| # |
Oct 8th 2018, 14:56 |
ricksaccous |
in saveStrategy replace, would it be possible to set replace conditions or something? |
| # |
Oct 8th 2018, 14:54 |
ricksaccous |
ok |
| # |
Oct 8th 2018, 14:54 |
martin |
no, only in before :( |
| # |
Oct 8th 2018, 14:53 |
ricksaccous |
but not in aftersave huh |
| # |
Oct 8th 2018, 14:53 |
martin |
and the fields are dirty that are changed |
| # |
Oct 8th 2018, 14:53 |
martin |
In the beforesave you have the orignal data |
| # |
Oct 8th 2018, 14:52 |
ricksaccous |
actually i want to compare old data with new data |
| # |
Oct 8th 2018, 14:52 |
ricksaccous |
is it possible to compare request data with data actually saved? |
| # |
Oct 8th 2018, 14:51 |
ricksaccous |
in cakephp3 aftersave |
| # |
Oct 8th 2018, 14:45 |
martin |
I know, walking tru the code now slowly checking where it stops :S |
| # |
Oct 8th 2018, 14:44 |
ricksaccous |
good luck |
| # |
Oct 8th 2018, 14:44 |
ricksaccous |
that's horrible |
| # |
Oct 8th 2018, 14:44 |
ricksaccous |
oh |
| # |
Oct 8th 2018, 14:44 |
martin |
did work till a few hours ago, thats why I don’t understand it :S |
| # |
Oct 8th 2018, 14:44 |
martin |
yes |
| # |
Oct 8th 2018, 14:42 |
ricksaccous |
have you read the server configuration set up instructions for cakephp3? |
| # |
Oct 8th 2018, 14:42 |
ricksaccous |
apache or nginx? |
| # |
Oct 8th 2018, 14:42 |
ricksaccous |
what are you using |
| # |
Oct 8th 2018, 14:41 |
martin |
nothing in logs already tried to enable debug and logging to be sure, but nothing, keeps loading |
| # |
Oct 8th 2018, 14:40 |
ricksaccous |
@martin have you checked the server logs, apache, and/or nginx? |