| # |
Feb 25th 2018, 21:10 |
Sigfried84 |
bye! |
| # |
Feb 25th 2018, 21:10 |
Sigfried84 |
late ^_^! |
| # |
Feb 25th 2018, 21:09 |
Sigfried84 |
if you're still here... |
| # |
Feb 25th 2018, 21:09 |
Sigfried84 |
just one more thing...how do i concatenate them? |
| # |
Feb 25th 2018, 21:08 |
 savant |
no problem, night |
| # |
Feb 25th 2018, 21:07 |
Sigfried84 |
Ok savant, I'll try to find out how tomorrow! Now I'm heading to bed! Thank you so much! |
| # |
Feb 25th 2018, 21:05 |
savant |
good luck :slightly_smiling_face: |
| # |
Feb 25th 2018, 21:05 |
savant |
find(‘list’) ^ |
| # |
Feb 25th 2018, 21:05 |
savant |
https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#finding-key-value-pairs |
| # |
Feb 25th 2018, 21:04 |
Sigfried84 |
i added a ->['contain' => ['Authors', 'AuthorTypes']] |
| # |
Feb 25th 2018, 21:04 |
savant |
im headed into the shower, but the above shows how to use contain |
| # |
Feb 25th 2018, 21:04 |
savant |
https://book.cakephp.org/3.0/en/orm/query-builder.html#loading-associations |
| # |
Feb 25th 2018, 21:03 |
savant |
you’d need to `contain` the extra tables - it’s like joining - and modify the `fields` that are retrieved for that find |
| # |
Feb 25th 2018, 21:03 |
Sigfried84 |
a concatenation of these fields? |
| # |
Feb 25th 2018, 21:02 |
Sigfried84 |
how and make it show author.name and author_type.name? |
| # |
Feb 25th 2018, 21:02 |
savant |
you’ll need to modify that find(‘list’) call to get it to show something other than the `id` as the displayField |
| # |
Feb 25th 2018, 21:02 |
savant |
so the authorities dropdown is populated by the Authorities->find(list) call |
| # |
Feb 25th 2018, 20:51 |
Sigfried84 |
Sorry for the delay |
| # |
Feb 25th 2018, 20:50 |
Sigfried84 |
Books/add.ctp https://www.irccloud.com/pastebin/3JuAw1Mr/ |
| # |
Feb 25th 2018, 20:49 |
Sigfried84 |
Books Controller https://www.irccloud.com/pastebin/QsV0ywdZ/ |
| # |
Feb 25th 2018, 20:41 |
Sigfried84 |
sure...let me fix some things...i messed up something ^_^! |
| # |
Feb 25th 2018, 20:33 |
savant |
can you gist the add.ctp and your BooksController.php as well |
| # |
Feb 25th 2018, 20:27 |
Sigfried84 |
(illustrators table is unnecessary...) |
| # |
Feb 25th 2018, 20:26 |
Sigfried84 |
https://www.irccloud.com/pastebin/LfFZynZ2/ |
| # |
Feb 25th 2018, 20:23 |
savant |
just trying to get you to actually show all the information so Im not guessing at what im looking at |
| # |
Feb 25th 2018, 20:22 |
Sigfried84 |
Sure I can |
| # |
Feb 25th 2018, 20:22 |
Sigfried84 |
lol...in no way was my intention to assume you don't know how it works. Sorry for that. |
| # |
Feb 25th 2018, 20:22 |
savant |
Can you show your _entire_ database schema? |
| # |
Feb 25th 2018, 20:21 |
savant |
if it helps to prove that, I’m one of the core developers |
| # |
Feb 25th 2018, 20:21 |
savant |
I know how cakephp works |
| # |
Feb 25th 2018, 20:21 |
Sigfried84 |
sorry I did not post books table because I thought field there were irrelevant as no fields refer to authorities, authors, etc. Bake deduces relation and includes an input with authorities_ids. |
| # |
Feb 25th 2018, 20:20 |
savant |
in your controller |
| # |
Feb 25th 2018, 20:20 |
savant |
you’d need to change the find call to do that |
| # |
Feb 25th 2018, 20:19 |
Sigfried84 |
well...the thing is how to get two join field to be a display field....so how author.name + author_type.name can be displayfield of authorities_books |
| # |
Feb 25th 2018, 20:19 |
savant |
where is the books table |
| # |
Feb 25th 2018, 20:16 |
Sigfried84 |
here :) https://www.irccloud.com/pastebin/o0GUan8M/ |
| # |
Feb 25th 2018, 20:13 |
savant |
im not asking for stuff from you for my health ;) |
| # |
Feb 25th 2018, 20:13 |
Sigfried84 |
:D |
| # |
Feb 25th 2018, 20:13 |
Sigfried84 |
lol..obviously no problem to show that! |
| # |
Feb 25th 2018, 20:13 |
Sigfried84 |
the thing is how can i get a a joined field to be a display field |
| # |
Feb 25th 2018, 20:13 |
savant |
but if you dont want to show the table schema because you think its not useful, thats fine, I dont need to help :slightly_smiling_face: |