| # |
Aug 27th 2019, 21:42 |
 ndm |
@ricksaccous There's probably 1000 and 1 ways... for example put both conditions in the HAVING clause, or split the query in two and use a UNION, or use the query with the HAVING clause as a subquery in an `OR IN ( ... )` condition, or or or... |
| # |
Aug 27th 2019, 20:31 |
kiwi_64 |
i selected 7.0 in cPanel and it gives me this error |
| # |
Aug 27th 2019, 20:31 |
kiwi_64 |
*Your version of PHP is 7.0.33 The version should be 7.0 |
| # |
Aug 27th 2019, 20:31 |
kiwi_64 |
any idea how to fix this error 'Your version of PHP is 5.6.40 The version should be 7.0' |
| # |
Aug 27th 2019, 20:07 |
ricksaccous |
where 'Model.id' => $id or $query->having(['field <=' 100]) |
| # |
Aug 27th 2019, 20:06 |
ricksaccous |
how would you do |
| # |
Aug 27th 2019, 18:58 |
ricksaccous |
https://github.com/dereuromark/cakephp-geo/blob/master/src/Model/Behavior/GeocoderBehavior.php |
| # |
Aug 27th 2019, 18:57 |
ricksaccous |
it seems i found something |
| # |
Aug 27th 2019, 18:49 |
ricksaccous |
what was your goto method for doing that? |
| # |
Aug 27th 2019, 18:49 |
ricksaccous |
has anyone had to do distance calculations between two lat/long points? |
| # |
Aug 27th 2019, 16:32 |
ricksaccous |
x) |
| # |
Aug 27th 2019, 16:31 |
neon1024 |
Later everyone :wave: |
| # |
Aug 27th 2019, 16:31 |
neon1024 |
:) |
| # |
Aug 27th 2019, 16:31 |
ricksaccous |
honestly i was kind of guessing |
| # |
Aug 27th 2019, 16:31 |
ricksaccous |
maybe you were right then, no problem |
| # |
Aug 27th 2019, 16:31 |
neon1024 |
Thanks for your time @ricksaccous :thumbsup: |
| # |
Aug 27th 2019, 16:31 |
ricksaccous |
oh dang it |
| # |
Aug 27th 2019, 16:31 |
neon1024 |
Hm, well that’s the end of the day for me |
| # |
Aug 27th 2019, 16:30 |
neon1024 |
Well adding `_joinData` to the `$_accessible` of my `Question` entity has prevented the join data marhslling into an entity |
| # |
Aug 27th 2019, 16:30 |
ricksaccous |
lol |
| # |
Aug 27th 2019, 16:29 |
ricksaccous |
but i'm too lazy |
| # |
Aug 27th 2019, 16:29 |
slackebot2 |
<neon1024> |
| # |
Aug 27th 2019, 16:29 |
ricksaccous |
prob allowing each field specifically is better though |
| # |
Aug 27th 2019, 16:29 |
ricksaccous |
i generally just leave my entities 'id' => false, '*' => true when it comes to accessibility |
| # |
Aug 27th 2019, 16:28 |
neon1024 |
Hm, I don’t see it anywhere. I’ll give that a try |
| # |
Aug 27th 2019, 16:28 |
ricksaccous |
i don't think cake just allows it magically unfortunately |
| # |
Aug 27th 2019, 16:28 |
neon1024 |
As it’s generated by the join |
| # |
Aug 27th 2019, 16:28 |
ricksaccous |
it does, and it should show up in the accessible array |
| # |
Aug 27th 2019, 16:27 |
neon1024 |
Well honestly, I wouldn’t know if `_joinData` was accessible or not. I don’t _think_ it needs tobe |
| # |
Aug 27th 2019, 16:27 |
neon1024 |
:male_mage: |
| # |
Aug 27th 2019, 16:27 |
ricksaccous |
okay lol |
| # |
Aug 27th 2019, 16:27 |
neon1024 |
Yus |
| # |
Aug 27th 2019, 16:27 |
ricksaccous |
TELL ME NOW |
| # |
Aug 27th 2019, 16:27 |
ricksaccous |
is it? |
| # |
Aug 27th 2019, 16:23 |
ricksaccous |
i just wanted to make sure _joinData was accessible in your questions entity |
| # |
Aug 27th 2019, 16:21 |
neon1024 |
Although the response FormEntity has a `questions` property which contains `_joinData` so I kinda followed that |
| # |
Aug 27th 2019, 16:20 |
neon1024 |
I wonder if I’ve put my `_joinData` in the wrong place :thinking_face: |
| # |
Aug 27th 2019, 16:20 |
neon1024 |
I’ve updated my Form and Question entity to add `sortorder` and I don’t see any changes :( |
| # |
Aug 27th 2019, 16:18 |
neon1024 |
Ah ok, yes, apologies! |
| # |
Aug 27th 2019, 16:18 |
ricksaccous |
that's not what's accessible in the Question entity itself is it |
| # |
Aug 27th 2019, 16:17 |
ricksaccous |
like i said that's join data |