| # |
May 27th 2016, 16:09 |
max-86666 |
suere, i think i'll use afterfind to parse that comma separated list |
| # |
May 27th 2016, 16:08 |
styks1987 |
the default looks like a redirect but I want a 401 response |
| # |
May 27th 2016, 16:08 |
 nemmons |
so less magic |
| # |
May 27th 2016, 16:08 |
nemmons |
you could, of course, still use cake for this. just not a cake association. |
| # |
May 27th 2016, 16:08 |
styks1987 |
where should I define a custom not authorized request for ajax authorization? |
| # |
May 27th 2016, 16:07 |
ypnos |
but can't :/ |
| # |
May 27th 2016, 16:07 |
ypnos |
yeah would love to make it easier for you |
| # |
May 27th 2016, 16:07 |
max-86666 |
i thought the same, but wanted to be sure :) |
| # |
May 27th 2016, 16:07 |
nemmons |
sorry =( |
| # |
May 27th 2016, 16:07 |
max-86666 |
well, thx for your advices :) |
| # |
May 27th 2016, 16:07 |
ypnos |
manifesting your bullshit db in fresh code is IMHO the worst you can do |
| # |
May 27th 2016, 16:06 |
ypnos |
but it will become a real performance problem |
| # |
May 27th 2016, 16:06 |
max-86666 |
but i can't :/ |
| # |
May 27th 2016, 16:06 |
ypnos |
and if you can't, maybe you can use SQL functions to build a VIEW that is usable |
| # |
May 27th 2016, 16:06 |
max-86666 |
can't agreee more |
| # |
May 27th 2016, 16:06 |
nemmons |
max-86666 sorry but i think what you're trying to do is probably too weird for Cake's ORM |
| # |
May 27th 2016, 16:06 |
ypnos |
me personally I would suggest you to fix your database |
| # |
May 27th 2016, 16:05 |
max-86666 |
so, you guys suggest me not to use cake's ORM ? |
| # |
May 27th 2016, 16:04 |
ionas |
especially if you think about ajax stuff that would do those pulls anway |
| # |
May 27th 2016, 16:04 |
ionas |
I wonder if a clean implementation of a pull flow instead of push flow and front controller will make things better |
| # |
May 27th 2016, 16:04 |
nemmons |
np. It's good info to have anyway, i'm sure it will come up for me at some point |
| # |
May 27th 2016, 16:04 |
ionas |
VzlaCaker: then |
| # |
May 27th 2016, 16:04 |
ionas |
nemmons true, sorry |
| # |
May 27th 2016, 16:03 |
nemmons |
@ionas thanks for the info but it was VzlaCaker who was asking |
| # |
May 27th 2016, 16:03 |
max-86666 |
if u tell me it's not possible, i'll believe you and make it raw query |
| # |
May 27th 2016, 16:03 |
ionas |
;) |
| # |
May 27th 2016, 16:03 |
ionas |
nemmon better yet, install parsedown and let them use markdown |
| # |
May 27th 2016, 16:03 |
ionas |
and h() |
| # |
May 27th 2016, 16:03 |
ionas |
nemmons: HtmlPurifier (google for HTML5 + HTML Purifier), DomDocument, Tidy |
| # |
May 27th 2016, 16:03 |
max-86666 |
sure, i can do it in raw sql, but i'd like to keep the magic from cake |
| # |
May 27th 2016, 16:02 |
max-86666 |
i guess FIND_IN_SET() |
| # |
May 27th 2016, 16:02 |
nemmons |
if you can't do it in SQL, then the ORM can't do it either |
| # |
May 27th 2016, 16:02 |
ionas |
~awesome |
| # |
May 27th 2016, 16:01 |
nemmons |
what he's asking you is, how would you write a SQL query to do what you want the CakeORM to do |
| # |
May 27th 2016, 16:01 |
max-86666 |
i'm quite stunned markstory is answering me, even if u can't help me :) |
| # |
May 27th 2016, 15:59 |
max-86666 |
i would like to use the Cake ORm to make my queries from controller, actually i use $critere = $this->Criteres->get($id, ['contain' => ['Users'] ]); |
| # |
May 27th 2016, 15:58 |
markstory |
What does a SQL query look like with these comma separated columns? |
| # |
May 27th 2016, 15:57 |
max-86666 |
in the initialize method of my table |
| # |
May 27th 2016, 15:56 |
markstory |
how do you write SQL to do your joins? |
| # |
May 27th 2016, 15:56 |
markstory |
You can't |
| # |
May 27th 2016, 15:55 |
max-86666 |
hellos everybedos, any clue on how i can link tables when foreign keys are store in a comma separated string ? (i can't change the DB design) |