# |
May 30th 2016, 04:01 |
voycey |
but it depends on how your table is laid out |
# |
May 30th 2016, 04:01 |
voycey |
left join sounds like what you want |
# |
May 30th 2016, 04:00 |
LckyBy517 |
voycey: you know what join type i would need in that case? |
# |
May 30th 2016, 03:59 |
kdcaker |
Well I am off to bed, Can't wait to pick it up again tomorrow, and share the results. Also I can't wait to contribute as well. I like this. Thanks! |
# |
May 30th 2016, 03:57 |
LckyBy517 |
basically all 34 tables have different data, i just wanna grab it from all of them, i tried left and inner and both duplicated a lot of the data, there might be multiple entries in one table per person, and i just wanna grab all that and add to whats returned |
# |
May 30th 2016, 03:56 |
LckyBy517 |
never know actually XD |
# |
May 30th 2016, 03:55 |
LckyBy517 |
i'm just not sure what join type i should be using LOL |
# |
May 30th 2016, 03:55 |
LckyBy517 |
yeah i know |
# |
May 30th 2016, 03:52 |
kdcaker |
I am not aware of how to enable the IDE debugger, I do have the Debug Tool kit on my browser tho- |
# |
May 30th 2016, 03:52 |
kdcaker |
Well, I haven't been able to do step by step debugging with Netbeans...I do have poor mans debugging and I see that my requests never enter the login method block. |
# |
May 30th 2016, 03:47 |
voycey |
LckyBy517: you can change the join type |
# |
May 30th 2016, 03:30 |
kdcaker |
I had a call @voycey, but thanks for the response |
# |
May 30th 2016, 03:30 |
kdcaker |
Let me try that |
# |
May 30th 2016, 03:09 |
voycey |
put a breakpoint on it in validation and see whats available |
# |
May 30th 2016, 03:06 |
aro |
but i need to pass the record to that constructor |
# |
May 30th 2016, 03:06 |
aro |
so i am creating $provider = new WhateverProvider(); |
# |
May 30th 2016, 03:06 |
aro |
i need my provider to not call statically |
# |
May 30th 2016, 03:05 |
aro |
when i add my provider by class name, i get errors for using $this when not in object context |
# |
May 30th 2016, 03:05 |
LckyBy517 |
LOL ok i need to figure out what join type i need ROFL. adding a third table i'm getting about a million results back per person now XD |
# |
May 30th 2016, 03:04 |
aro |
i did a debug on that and i got no property |
# |
May 30th 2016, 03:03 |
voycey |
$this->id? |
# |
May 30th 2016, 03:03 |
aro |
is there a way to get the current record being validated from inside the validator function in a model |
# |
May 30th 2016, 02:52 |
kdcaker |
I am sorry I got kicked off the chat somehow |
# |
May 30th 2016, 02:51 |
LckyBy517 |
then realize the error was in another file XD facepalm |
# |
May 30th 2016, 02:32 |
kdcaker |
It is; I need to know/ or see at least what is needed for a custom router class, and how to resolve my authorization issue with the login in method. |
# |
May 30th 2016, 02:30 |
voycey |
kdcaker: was that a question? |
# |
May 30th 2016, 02:29 |
kdcaker |
I am using cake v 2.9 btw |
# |
May 30th 2016, 02:28 |
kdcaker |
Aside from the default routing class provided, I know I need connect statements, and I have them written in the default class now. |
# |
May 30th 2016, 02:22 |
LckyBy517 |
i feel like both php-fpm and mysql are gonna go uggggghhh everytime i make that query ROFL |
# |
May 30th 2016, 02:21 |
LckyBy517 |
ok |
# |
May 30th 2016, 02:21 |
voycey |
if you get all the associations done then yes |
# |
May 30th 2016, 02:21 |
LckyBy517 |
the app? java |
# |
May 30th 2016, 02:21 |
LckyBy517 |
once i do that though i'll be able to make one call like $this->find('all')->contains(['each, of, the, associated, tables here]); right? |
# |
May 30th 2016, 02:20 |
voycey |
what is it coded in? |
# |
May 30th 2016, 02:20 |
LckyBy517 |
sounds likea project for tomorrow LOL |
# |
May 30th 2016, 02:20 |
LckyBy517 |
dang, ok well this is gonna take a bit hahah XD |
# |
May 30th 2016, 02:20 |
voycey |
hasOne / Many and belongsTo |
# |
May 30th 2016, 02:20 |
voycey |
cake has no way of knowing what tables it links to - it doesnt read database contraints |
# |
May 30th 2016, 02:20 |
LckyBy517 |
this->has(One/Many) for each dang table? |
# |
May 30th 2016, 02:19 |
LckyBy517 |
like i was starting to do hmmm |
# |
May 30th 2016, 02:19 |
voycey |
you are going to have to build your associations your self |