# |
Jul 2nd 2018, 15:16 |
camdenbassett |
There's a pastebin of all the approaches I've tried. Any pointers would be appreciated. |
# |
Jul 2nd 2018, 15:15 |
camdenbassett |
https://thepasteb.in/p/Y6hkvRl9rgxf7 |
# |
Jul 2nd 2018, 15:15 |
camdenbassett |
Hello everyone. I'm running a custom mysql "REPLACE INTO" statement via the connection object, and I can't seem to figure out how to get the id of the inserted row. |
# |
Jul 2nd 2018, 15:14 |
afdm74 |
@lorenzo Will try that, thanks! |
# |
Jul 2nd 2018, 15:10 |
rudy1976s |
which are not directly related to cake queries |
# |
Jul 2nd 2018, 15:10 |
rudy1976s |
we have traced logs and performance monitor and there are plenty of queries generated many times |
# |
Jul 2nd 2018, 15:09 |
rudy1976s |
and we need to understad if they depends on some missing PDO setting |
# |
Jul 2nd 2018, 15:08 |
rudy1976s |
we are detecting a lot of strange queries created by sqlserver when working on it |
# |
Jul 2nd 2018, 15:07 |
lorenzo |
@rudy1976s what do you need to change? |
# |
Jul 2nd 2018, 15:07 |
lorenzo |
@afdm74 I recommend this plugin that will help you do that https://github.com/FriendsOfCake/search |
# |
Jul 2nd 2018, 15:06 |
rudy1976s |
I need to tweak it because we are facing performance problem using cake on sqlserver |
# |
Jul 2nd 2018, 15:06 |
rudy1976s |
@lorenzo thank you |
# |
Jul 2nd 2018, 15:06 |
lorenzo |
you need to make the post arguments into get arguments |
# |
Jul 2nd 2018, 15:03 |
afdm74 |
Hi guys, Having trouble using pagination and custom queries. When clicking in next page it loses all filter information and display a Not Found page. I debugged it and the reason is because the Paginator uses Get requests. The paginator is not geeting or keeping the filters and resetting when clicked on the next page. What am I doing wrong? |
# |
Jul 2nd 2018, 15:03 |
lorenzo |
it shuld be `[PDO::CONSTANT_THING => $value]` |
# |
Jul 2nd 2018, 15:00 |
rudy1976s |
@lorenzo, so the array should only contain PDO constants or should I need to add as [‘pdo_name’ => ‘pdo_constant’] |
# |
Jul 2nd 2018, 14:52 |
lorenzo |
you need to use the constants |
# |
Jul 2nd 2018, 14:52 |
lorenzo |
yeah, it can be any PDO flag |
# |
Jul 2nd 2018, 14:47 |
rudy1976s |
I need to add some PDO flag to the sql server datasources: I know from docs this is supported, but the associative array could contain all PDO supported flag ? and what is the correct names to build associative array ? on pdo docs I was only able to find the constants |
# |
Jul 2nd 2018, 14:45 |
itmpls |
good morning |
# |
Jul 2nd 2018, 14:45 |
rudy1976s |
good afternoon |
# |
Jul 2nd 2018, 14:10 |
dereuromark |
PRs |
# |
Jul 2nd 2018, 14:10 |
qq |
@dereuromark how to improve the cakephp documents in Chinese? the Chinese(zh) document has not been updated for ages. |
# |
Jul 2nd 2018, 14:06 |
itmpls |
it happens to all of us :slightly_smiling_face: np |
# |
Jul 2nd 2018, 14:06 |
rrd564 |
:slightly_smiling_face: |
# |
Jul 2nd 2018, 14:06 |
rrd564 |
eh what a silly mistake |
# |
Jul 2nd 2018, 14:05 |
rrd564 |
@itmpls thanks, that was it! |
# |
Jul 2nd 2018, 14:04 |
itmpls |
try ^ |
# |
Jul 2nd 2018, 14:04 |
rrd564 |
I used Datalist.php |
# |
Jul 2nd 2018, 14:04 |
itmpls |
does it need to be DatalistWidget.php ? |
# |
Jul 2nd 2018, 14:04 |
itmpls |
filename? |
# |
Jul 2nd 2018, 14:04 |
rrd564 |
and the first parameter of format |
# |
Jul 2nd 2018, 14:03 |
rrd564 |
Except the classname |
# |
Jul 2nd 2018, 14:03 |
rrd564 |
https://book.cakephp.org/3.0/en/views/helpers/form.html#building-a-widget-class |
# |
Jul 2nd 2018, 14:03 |
rrd564 |
So now it is exactly the same what we have in the cookbook |
# |
Jul 2nd 2018, 14:03 |
itmpls |
oh ok |
# |
Jul 2nd 2018, 14:03 |
rrd564 |
I just started to rorking on ti |
# |
Jul 2nd 2018, 14:03 |
itmpls |
pastebin* |
# |
Jul 2nd 2018, 14:02 |
itmpls |
can you paste the class definition? |
# |
Jul 2nd 2018, 14:02 |
rrd564 |
in Datalist.php `namespace App\View\Widget;` |
# |
Jul 2nd 2018, 14:02 |
itmpls |
does it have the right namespace? |