| # |
Apr 27th 2017, 12:33 |
Neon1024 |
(thumbsup) |
| # |
Apr 27th 2017, 12:32 |
 birdy247 |
thansk for the tips |
| # |
Apr 27th 2017, 12:32 |
birdy247 |
I got that function to "merge" accounts working yesterday |
| # |
Apr 27th 2017, 12:32 |
birdy247 |
Hey Neon1024 |
| # |
Apr 27th 2017, 12:26 |
Neon1024 |
Afternoon everyone |
| # |
Apr 27th 2017, 12:13 |
inoas |
aka using inner join |
| # |
Apr 27th 2017, 12:13 |
inoas |
https://gist.github.com/inoas/e127826d9c9be368757169bbb370f2e0#gistcomment-2076285 |
| # |
Apr 27th 2017, 12:13 |
inoas |
but this should be transformable to ORM code |
| # |
Apr 27th 2017, 12:13 |
inoas |
it is already doing subqueries - the problem was that WHERE doesn't support composite identifiers on the left side |
| # |
Apr 27th 2017, 12:12 |
hiromi2424 |
inoas possible.search subquery on the cookbook |
| # |
Apr 27th 2017, 12:04 |
inoas |
WHERE (id, revision_id) IN (subquery)? |
| # |
Apr 27th 2017, 12:04 |
inoas |
AND (id, revision_id) IN ( |
| # |
Apr 27th 2017, 12:04 |
inoas |
is this possible in the 3.x ORM? |
| # |
Apr 27th 2017, 11:37 |
paul_83uk |
@inoas From what i can see in the source this is correct use of TableRegistry and it just gets and stores the Table in the registry once: ```for ($i = 0 ; $i count($this->user_accesses) ; $i++) { $this->user_accesses[$i]->jobId = $jobId; TableRegistry::get('UserAccesses')->save($this-user_accesses[$i]; ... ``` |
| # |
Apr 27th 2017, 11:29 |
dereuromark |
Jonas: Most Like These should be CI for a reason :) ich |
| # |
Apr 27th 2017, 11:18 |
inoas |
but sounds kinda wrong to me |
| # |
Apr 27th 2017, 11:18 |
inoas |
if you are creating say 100 table class objects |
| # |
Apr 27th 2017, 11:18 |
inoas |
paul_83k as that is pretty non standard I'd just either look into the source or save it in an array and after the loop is over unset |
| # |
Apr 27th 2017, 11:14 |
inoas |
lets try :) |
| # |
Apr 27th 2017, 11:14 |
inoas |
cool https://book.cakephp.org/3.0/en/orm/query-builder.html#case-statements |
| # |
Apr 27th 2017, 11:10 |
inoas |
if it exists. |
| # |
Apr 27th 2017, 11:10 |
inoas |
basically when you enter a domain and I have to real link objects I want to redirect to a nice slug "in your language" |
| # |
Apr 27th 2017, 11:10 |
inoas |
dereuromark that's the reason I want case sensitivity... probably ascii_ci will work ok but meh |
| # |
Apr 27th 2017, 11:09 |
inoas |
forgot the gist |
| # |
Apr 27th 2017, 11:09 |
inoas |
https://gist.github.com/inoas/e127826d9c9be368757169bbb370f2e0 |
| # |
Apr 27th 2017, 11:07 |
inoas |
lorenzo is there a sane way to convert this sql expression into a query, I have to loop through a list of locales and fill in the AND/OR and the ORDER BY CASE statements |
| # |
Apr 27th 2017, 11:04 |
clementcrownrise |
@paul_83uk, and clackebot1, have you helped me to try it? |
| # |
Apr 27th 2017, 10:51 |
clementcrownrise |
please let me know if anyone can login with the details above, thanks |
| # |
Apr 27th 2017, 10:51 |
clementcrownrise |
ok, please, let me send you a username and password , let me know if you are able to login, username:clementcrownrise@gmail.com , password: password |
| # |
Apr 27th 2017, 10:45 |
chris-andre |
No error or notification. The page shows a login form like @paul_83uk mentioned. |
| # |
Apr 27th 2017, 10:31 |
clementcrownrise |
@slackebot1 please does the page show any notification or error? |
| # |
Apr 27th 2017, 10:29 |
paul_83uk |
shows a login form |
| # |
Apr 27th 2017, 10:29 |
paul_83uk |
@clementcrownrise that page loads for me make sure you have cleared your cache in your browser |
| # |
Apr 27th 2017, 10:28 |
clementcrownrise |
I dont now why this page doesnt load, http://www.wacscoac.org/edms/users/login but it works perfecly on my localhost, but it deoesnt load after uploading , this is a cakephp 2.x application |
| # |
Apr 27th 2017, 10:28 |
paul_83uk |
guessing by the fact theres a ::clear() it is stored. Just wondering the overhead differences I've always assigned to a variable but Cakes own code doesn't seem to bother |
| # |
Apr 27th 2017, 10:25 |
paul_83uk |
Hi All, does TableRegistry::get(alias) cache the result? As in if I'm looping through an array should I assign the get to a variable or does cake cache it so I don't need to worry? |
| # |
Apr 27th 2017, 09:56 |
clementcrownrise |
can anyone please help me on this issue? |
| # |
Apr 27th 2017, 09:44 |
clementcrownrise |
I dont now why this page doesnt load, http://www.wacscoac.org/edms/users/login but it works perfecly on my localhost, but it deoesnt load after uploading |
| # |
Apr 27th 2017, 09:43 |
clementcrownrise |
Hi |
| # |
Apr 27th 2017, 09:15 |
julez |
'mime' => ['rule' => ['mimeType', ['application/pdf', 'application/octet-stream', 'application/x-unknown']]] |
| # |
Apr 27th 2017, 09:14 |
julez |
the validation rule i use is exact the same as in another part of my application |