| # |
May 28th 2016, 08:57 |
 savant |
all the websites are being relaunched |
| # |
May 28th 2016, 08:57 |
birdy247 |
Oh my! |
| # |
May 28th 2016, 08:56 |
savant |
try going to http://cakephp.org|cakephp.org |
| # |
May 28th 2016, 08:56 |
birdy247 |
what are the new site launches? |
| # |
May 28th 2016, 08:55 |
savant |
missed this year, had a few personal things to get through |
| # |
May 28th 2016, 08:55 |
birdy247 |
ah, long way to go |
| # |
May 28th 2016, 08:55 |
savant |
im in nyc |
| # |
May 28th 2016, 08:55 |
savant |
no |
| # |
May 28th 2016, 08:55 |
birdy247 |
are you at cakefest? |
| # |
May 28th 2016, 08:55 |
savant |
hai |
| # |
May 28th 2016, 08:55 |
birdy247 |
@savant: morning |
| # |
May 28th 2016, 08:29 |
phpcoder |
yes it works perfectly! |
| # |
May 28th 2016, 08:27 |
savant |
basically exactly what you thought it might be :slightly_smiling_face: |
| # |
May 28th 2016, 08:27 |
savant |
good to know you can change an alias |
| # |
May 28th 2016, 08:27 |
savant |
:) |
| # |
May 28th 2016, 08:27 |
savant |
look at you, looking at docs |
| # |
May 28th 2016, 08:26 |
savant |
oh fancy |
| # |
May 28th 2016, 08:26 |
phpcoder |
@savant http://api.cakephp.org/3.2/class-Cake.Database.Query.html#_from |
| # |
May 28th 2016, 08:17 |
phpcoder |
) no problem @savant |
| # |
May 28th 2016, 08:17 |
phpcoder |
i am writing the code let see if it works |
| # |
May 28th 2016, 08:17 |
savant |
sorry, quite late for me, not running on all my batteries right now :( |
| # |
May 28th 2016, 08:17 |
savant |
interesting. not sure, maybe @lorenzo might know (though he's probably a bit asleep atm) |
| # |
May 28th 2016, 08:16 |
phpcoder |
the same table twice savant |
| # |
May 28th 2016, 08:16 |
phpcoder |
i have to use it twice |
| # |
May 28th 2016, 08:16 |
phpcoder |
yes |
| # |
May 28th 2016, 08:11 |
savant |
Which one of those is it? |
| # |
May 28th 2016, 08:11 |
savant |
or if you want to select from another table completely |
| # |
May 28th 2016, 08:10 |
savant |
If you just want to use Agents in there twice |
| # |
May 28th 2016, 08:09 |
savant |
whats the overall query you want to get? |
| # |
May 28th 2016, 08:08 |
phpcoder |
but with a different alias because i use it in a query on select() (on the main query) |
| # |
May 28th 2016, 08:08 |
savant |
so just use that code? |
| # |
May 28th 2016, 08:08 |
phpcoder |
the same as TableRegistry::get('Agents')->find()->select()->where()->all() |
| # |
May 28th 2016, 08:06 |
savant |
what is the exact query you want |
| # |
May 28th 2016, 08:06 |
phpcoder |
? |
| # |
May 28th 2016, 08:06 |
phpcoder |
should i set it using ->from() |
| # |
May 28th 2016, 08:05 |
phpcoder |
i do not need to use "Agents" alias |
| # |
May 28th 2016, 08:05 |
phpcoder |
if i do TableRegistry::get('Agents')->find()->select()->where()->all() |
| # |
May 28th 2016, 08:05 |
savant |
like a cakephp table alias, or a sql alias |
| # |
May 28th 2016, 08:05 |
savant |
what do you mean, a different alias? |
| # |
May 28th 2016, 08:05 |
hmic |
!tell phpcoder about why |
| # |
May 28th 2016, 08:03 |
phpcoder |
guys can i do a simpple query using a different alias? (i am not talking about joins...) just a SELECT... FROM.... WHERE |