# |
May 16th 2019, 09:20 |
TheScreamer |
Hi Hi ! when i save my data my database one field stay empty either there is a value in it can you help me ? screen are comming |
# |
May 16th 2019, 08:58 |
dereuromark |
i am happy to outsource things :slightly_smiling_face: |
# |
May 16th 2019, 08:57 |
admad |
@neon1024 all noteworthy changes are noted in the 4.0 migration guide as and when they are done on the manual repo |
# |
May 16th 2019, 08:57 |
dereuromark |
most changes are quite final already. |
# |
May 16th 2019, 08:56 |
admad |
@dereuromark probably everyone is waiting for you, you are the upgrade master :slightly_smiling_face: |
# |
May 16th 2019, 08:52 |
neon1024 |
Unless you have the time to track all the changes in the core |
# |
May 16th 2019, 08:52 |
neon1024 |
Probably worth waiting for 4.0.0-RC1 |
# |
May 16th 2019, 08:44 |
dereuromark |
did anyone start 4.0 rector config yet? https://github.com/rectorphp/rector/tree/master/config/level/cakephp |
# |
May 16th 2019, 08:00 |
dereuromark |
neofutur: why do u have 2 empty values? do they mean different things for u? |
# |
May 16th 2019, 07:26 |
egalles |
* sorry replay is repeated |
# |
May 16th 2019, 07:26 |
egalles |
'WicPacks.amount_wildcard' => 'DESC', 'WicPacks.amount_replay' => 'DESC', 'WicPacks.amount_pause' => 'DESC', 'WicPacks.amount_replay' => 'DESC' |
# |
May 16th 2019, 07:26 |
egalles |
the real query is |
# |
May 16th 2019, 07:25 |
egalles |
I have a product and I have some "packs", what I want is to order some packs by its category number of pluses |
# |
May 16th 2019, 07:24 |
egalles |
no, it's an example |
# |
May 16th 2019, 07:22 |
dereuromark |
but it does not make much sense in your case. or asre those items created with the same timestamp? |
# |
May 16th 2019, 07:21 |
dereuromark |
the first |
# |
May 16th 2019, 07:20 |
egalles |
['Articles.created','Articles.modified, ...' => 'DESC' ] ? |
# |
May 16th 2019, 07:19 |
egalles |
or |
# |
May 16th 2019, 07:19 |
egalles |
['Articles.created' => 'DESC', 'Articles.modified' => 'DESC'] ? |
# |
May 16th 2019, 07:18 |
egalles |
if I want to order some fields which is the best way to order multiple fields: |
# |
May 16th 2019, 07:18 |
egalles |
I have a little question about order of a query |
# |
May 16th 2019, 07:18 |
egalles |
Good morning |
# |
May 16th 2019, 07:06 |
neofutur |
thanks ! |
# |
May 16th 2019, 07:03 |
admad |
The final query run on db would also be shown in the SQL tab of debugkit |
# |
May 16th 2019, 07:03 |
admad |
->sql() not ->toSql() |
# |
May 16th 2019, 07:02 |
admad |
debug($consents) or debug($consents->toSql()) |
# |
May 16th 2019, 06:48 |
neofutur |
the final sql query |
# |
May 16th 2019, 06:48 |
neofutur |
err ow can I check that ? |
# |
May 16th 2019, 06:31 |
admad |
did you check the generated SQL? |
# |
May 16th 2019, 06:15 |
neofutur |
full query on https://pastebin.com/TMeWK3xt |
# |
May 16th 2019, 06:13 |
neofutur |
will return nothing |
# |
May 16th 2019, 06:13 |
neofutur |
} |
# |
May 16th 2019, 06:13 |
neofutur |
return $qmail |
# |
May 16th 2019, 06:13 |
neofutur |
-> where (['Prospects.email IS NOT NULL', 'Prospects.email !=' => ''] ); |
# |
May 16th 2019, 06:13 |
neofutur |
{ |
# |
May 16th 2019, 06:13 |
neofutur |
->contain(['Prospects'], function( Query $qmail ) |
# |
May 16th 2019, 06:10 |
neofutur |
ok, thanks I ll try that ! |
# |
May 16th 2019, 06:09 |
admad |
neofutur: ['Prospects.email IS NOT NULL', 'Prospects.email !=' => ''] |
# |
May 16th 2019, 06:04 |
neofutur |
but i cant find the good syntax :( |
# |
May 16th 2019, 06:03 |
neofutur |
soething like -> where (['Prospects.email'] => NOT NULL AND NOT EMPTY ); |
# |
May 16th 2019, 05:57 |
neofutur |
i need to pass a condition to the contain table , to check that a field is NOT NULL and also nt empty |