# |
Nov 30th 2017, 15:50 |
unclezoot |
(a LOT simpler) |
# |
Nov 30th 2017, 15:50 |
casmo |
Yeah, preferbly with Tablename in front of it |
# |
Nov 30th 2017, 15:50 |
unclezoot |
ill give it a go, thanks |
# |
Nov 30th 2017, 15:49 |
hmic |
you can just ->where(['publish_to IS' => null]) |
# |
Nov 30th 2017, 15:49 |
hmic |
no |
# |
Nov 30th 2017, 15:49 |
unclezoot |
thing is I need to check for NULL (where is null) so having to go down the expression builder route |
# |
Nov 30th 2017, 15:48 |
casmo |
Should work |
# |
Nov 30th 2017, 15:48 |
casmo |
->where(['or' => [['A' => 1, 'B' => 1]], ['C' => 1, 'D' => 1]]); |
# |
Nov 30th 2017, 15:48 |
hmic |
i dont think the code you show does work at all |
# |
Nov 30th 2017, 15:47 |
hmic |
unclezoot, there is a between expression you could use? |
# |
Nov 30th 2017, 15:46 |
unclezoot |
last attempt: https://www.pastiebin.com/5a2027c8655db |
# |
Nov 30th 2017, 15:44 |
unclezoot |
i.e. WHERE (A AND B) OR (C AND D) |
# |
Nov 30th 2017, 15:44 |
unclezoot |
could anyone give me some pointers on the cake ORM, specifically how to generate this WHERE condition: WHERE (publish_from <= CURRENT_DATE AND publish_to >= CURRENT_DATE) OR (publish_from is NULL AND publish_to IS NULL) |
# |
Nov 30th 2017, 15:43 |
h.mavisakalian |
“Warning (4096): Object of class Cake\View\Helper\FormHelper could not be converted to string” |
# |
Nov 30th 2017, 15:42 |
h.mavisakalian |
but works |
# |
Nov 30th 2017, 15:42 |
h.mavisakalian |
still gives that warning |
# |
Nov 30th 2017, 15:42 |
h.mavisakalian |
I did |
# |
Nov 30th 2017, 15:38 |
casmo |
test |
# |
Nov 30th 2017, 15:32 |
casmo |
And even better solutions than mine |
# |
Nov 30th 2017, 15:32 |
casmo |
Here is more info about the Form templates: https://book.cakephp.org/3.0/en/views/helpers/form.html#customizing-the-templates-formhelper-uses |
# |
Nov 30th 2017, 15:31 |
h.mavisakalian |
@casmo s solution |
# |
Nov 30th 2017, 15:31 |
kaliel |
what worked ? |
# |
Nov 30th 2017, 15:30 |
h.mavisakalian |
Object of class Cake\View\Helper\FormHelper could not be converted to string |
# |
Nov 30th 2017, 15:30 |
h.mavisakalian |
but I get a warning |
# |
Nov 30th 2017, 15:30 |
h.mavisakalian |
it worked |
# |
Nov 30th 2017, 15:28 |
casmo |
$this->Form->setTemplates(['inputContainer' => '{{content}}']); for example |
# |
Nov 30th 2017, 15:28 |
casmo |
Mavisakalian, this is done through templates |
# |
Nov 30th 2017, 15:28 |
kaliel |
$this->Form->input() |
# |
Nov 30th 2017, 15:27 |
kaliel |
change method from control() to input() |
# |
Nov 30th 2017, 15:26 |
h.mavisakalian |
div => false - doesn’t work |
# |
Nov 30th 2017, 15:26 |
h.mavisakalian |
Can anyone tell me how to remove the input wrap in the latest version ( 3.5 ) |
# |
Nov 30th 2017, 15:16 |
kaliel |
you mean production app ? |
# |
Nov 30th 2017, 15:15 |
hmic |
i'd not put stuff thats not my app into src |
# |
Nov 30th 2017, 15:14 |
kaliel |
@hmic, yes this is what i do, but i like to have different thoughts |
# |
Nov 30th 2017, 15:14 |
hmic |
kaliel: why not create a dir for them? |
# |
Nov 30th 2017, 15:13 |
kaliel |
is /src a good choice ? |
# |
Nov 30th 2017, 15:13 |
kaliel |
hey guys, i'd like to know where's the best place / the place you use, to store frontend dev files (scss, es6, etc..) in a cake project ? |
# |
Nov 30th 2017, 15:01 |
neon1024 |
Sure you can, but you’ll need to manually marshal them |
# |
Nov 30th 2017, 14:59 |
obinoob |
neon1024 hold on, so i can't have inputs named like: name, address, district_id, town_id ?? |
# |
Nov 30th 2017, 14:52 |
AlexMax |
Question - is there some easy way to hydrate the invisible 'rowid' row when using sqlite3? |
# |
Nov 30th 2017, 14:50 |
neon1024 |
Do bear in mind that singular associations will be automatically marshalled only if the form name is singular as well, so the array matches the entity properties |