# |
Dec 7th 2017, 10:46 |
joopm |
i have a little issue |
# |
Dec 7th 2017, 10:46 |
joopm |
have a great day to all community members |
# |
Dec 7th 2017, 10:46 |
joopm |
hello there |
# |
Dec 7th 2017, 10:41 |
skor |
ok solved it :grinning: nvm |
# |
Dec 7th 2017, 10:38 |
kryptonita |
@dereuromark thanks |
# |
Dec 7th 2017, 10:38 |
skor |
do i have to wrap it into another expression? |
# |
Dec 7th 2017, 10:37 |
skor |
im doing this: $jsearch = new FunctionExpression(‘JSON_SEARCH’, [‘PropertyValues.value’ => ‘literal’, ‘all’, $value]); and add $jsearch to an where OR, but i dont know how to add the is not null part |
# |
Dec 7th 2017, 10:36 |
skor |
has anyone done a query like this? … `where JSON_SEARCH(value, 'all', 123321) is not null` 123321 is user input so i would like to avoid raw expressions |
# |
Dec 7th 2017, 10:33 |
dereuromark |
see my response in your ticket |
# |
Dec 7th 2017, 10:32 |
dereuromark |
oh, actually it is not: https://github.com/cakephp/cakephp/blob/master/src/Error/ExceptionRenderer.php#L88 |
# |
Dec 7th 2017, 10:31 |
dereuromark |
This should be fixed in latest dev-master afaik |
# |
Dec 7th 2017, 10:31 |
dereuromark |
I think the error handler is hardcoded on typehint of php5, remove the typehint |
# |
Dec 7th 2017, 10:30 |
dereuromark |
in your ticket you need to be a bit more specific, how does the error occur? whats the strack trace etc? |
# |
Dec 7th 2017, 10:27 |
kryptonita |
the order is correct. I dont know why irc changed the order |
# |
Dec 7th 2017, 10:26 |
dereuromark |
the order? |
# |
Dec 7th 2017, 10:24 |
kryptonita |
``` |
# |
Dec 7th 2017, 10:24 |
kryptonita |
$category = $categories->findByName('Banda Desenhada'); |
# |
Dec 7th 2017, 10:24 |
kryptonita |
$categories = TableRegistry::get('Categories'); |
# |
Dec 7th 2017, 10:24 |
kryptonita |
``` |
# |
Dec 7th 2017, 10:24 |
kryptonita |
Hello , whats wrong with this code: |
# |
Dec 7th 2017, 09:55 |
skor |
i guess FunctionExpression, … |
# |
Dec 7th 2017, 09:50 |
skor |
can i create it with find()->func() ? |
# |
Dec 7th 2017, 09:47 |
skor |
from the docs i can see `A number of commonly used functions can be created with the func() method` so i guess my JSON_SEARCH isnt common, |
# |
Dec 7th 2017, 09:43 |
skor |
FunctionExpression ? queryexpression ? |
# |
Dec 7th 2017, 09:43 |
skor |
i keep forgetting, how do i write a custom function? i need to do this in the db: ‘JSON_SEARCH(PropertyValues.value, “all”, “’ . $value . ‘“) is not’ => null, |
# |
Dec 7th 2017, 09:42 |
ono-t |
good morning |
# |
Dec 7th 2017, 09:42 |
skor |
hey all! |
# |
Dec 7th 2017, 09:37 |
neon1024 |
Morning everyone |
# |
Dec 7th 2017, 08:17 |
saeideng |
then you can setup 2 config for it on table/behavior |
# |
Dec 7th 2017, 08:17 |
saeideng |
image1 and image 2 |
# |
Dec 7th 2017, 08:16 |
saeideng |
@ra7bi for uploading file use 2 name |
# |
Dec 7th 2017, 06:55 |
jkpatel291289 |
one problem here is password not being hashed. |
# |
Dec 7th 2017, 06:54 |
jkpatel291289 |
this code is working is this right way? |
# |
Dec 7th 2017, 06:54 |
slackebot |
$table->insert($data)->save(); $data = [ [ 'user_name'=>'jay', 'email'=>'jay@vct.com', 'password'=>'jay', 'company_id'=>1, ], ]; $table = $this->table('users'); $table->insert($data)->save(); |
# |
Dec 7th 2017, 06:54 |
slackebot |
'current_financial_year' => '2016-2017', 'organization_start_date' => '2017-12-06', 'currency_name' => 'Rs', 'currency_symbol' => 'rs', 'currency_subname' => 'rs', 'symbol_of_partition' => ',', 'symbol_to_print' => 'rs', 'multi_currency_management' => '0', ], ]; $table = $this->table('companies'); |
# |
Dec 7th 2017, 06:54 |
jkpatel291289 |
$data = [ [ 'id' => '1', 'name' => 'V C transport', 'print_name' => 'VC transport', 'address_line1' => '12, umargaun gidc', 'address_line2' => '3rd phase', 'city' => 'umaergaon', 'state' => 'gujarat', 'country' => 'india', 'pincode' => '396195', |
# |
Dec 7th 2017, 06:53 |
admad |
yes |
# |
Dec 7th 2017, 06:52 |
jkpatel291289 |
ok. so i have to create them one by one manually? |
# |
Dec 7th 2017, 06:50 |
admad |
phinx seed files don't use cake's orm |
# |
Dec 7th 2017, 06:34 |
jkpatel291289 |
comapany has many user ( association) |
# |
Dec 7th 2017, 06:34 |
jkpatel291289 |
why this is not working? |