| # |
Oct 4th 2018, 15:41 |
 rudy1976s |
the attachments table has some rows : item id which is a varchar 255 where I normally store the associated foreign key |
| # |
Oct 4th 2018, 15:41 |
ricksaccous |
lol |
| # |
Oct 4th 2018, 15:41 |
ricksaccous |
that's why i want to see the rows |
| # |
Oct 4th 2018, 15:40 |
ricksaccous |
how does that even work then... |
| # |
Oct 4th 2018, 15:40 |
rudy1976s |
but that table is also used to store attachments for models which does not use CFK |
| # |
Oct 4th 2018, 15:39 |
ricksaccous |
you could split item_id into two fields |
| # |
Oct 4th 2018, 15:39 |
ricksaccous |
or |
| # |
Oct 4th 2018, 15:39 |
rudy1976s |
I cannot actually print row |
| # |
Oct 4th 2018, 15:39 |
angelxmoreno |
greeting bakers! |
| # |
Oct 4th 2018, 15:38 |
ricksaccous |
rather than two to one key |
| # |
Oct 4th 2018, 15:38 |
ricksaccous |
I think I'd recommend just making it so the relationship is more of a key to key |
| # |
Oct 4th 2018, 15:35 |
ricksaccous |
I'm not sure i can solve your problem, but i'm curious about it, lol |
| # |
Oct 4th 2018, 15:34 |
rudy1976s |
sure |
| # |
Oct 4th 2018, 15:34 |
ricksaccous |
can i see a sample row of both tables |
| # |
Oct 4th 2018, 15:34 |
rudy1976s |
I see that cake saves CFK using keys plus ";" |
| # |
Oct 4th 2018, 15:34 |
rudy1976s |
it should |
| # |
Oct 4th 2018, 15:32 |
ricksaccous |
is item_id a concat of code and category_id or something |
| # |
Oct 4th 2018, 15:32 |
rudy1976s |
code and category is are in the Products Group table and item_id on Attachments table |
| # |
Oct 4th 2018, 15:32 |
ricksaccous |
what two fields match in those tables |
| # |
Oct 4th 2018, 15:32 |
ricksaccous |
?? |
| # |
Oct 4th 2018, 15:31 |
ricksaccous |
but i'm saying, wouldn't the keys have to correspond |
| # |
Oct 4th 2018, 15:31 |
rudy1976s |
I have a single table used for attachments |
| # |
Oct 4th 2018, 15:30 |
ricksaccous |
what logic would you even use for that |
| # |
Oct 4th 2018, 15:30 |
ricksaccous |
how does code and category id correspond to foreignKey though, heh |
| # |
Oct 4th 2018, 15:29 |
rudy1976s |
snippet of the table |
| # |
Oct 4th 2018, 15:29 |
rudy1976s |
https://gist.github.com/rudy1976s/59edd5dbf8940975677d6823822a9fca |
| # |
Oct 4th 2018, 15:29 |
rudy1976s |
yes |
| # |
Oct 4th 2018, 15:29 |
ricksaccous |
@rudy1976s correct? |
| # |
Oct 4th 2018, 15:28 |
ricksaccous |
and binding Key is the array of two keys |
| # |
Oct 4th 2018, 15:28 |
ricksaccous |
so when you set foreignKey it should be a string value of the field |
| # |
Oct 4th 2018, 15:28 |
ricksaccous |
? |
| # |
Oct 4th 2018, 15:28 |
ricksaccous |
and foreign key is one field |
| # |
Oct 4th 2018, 15:28 |
ricksaccous |
so binding key is composite |
| # |
Oct 4th 2018, 15:27 |
rudy1976s |
but in the Attachment table I don't need composite keys |
| # |
Oct 4th 2018, 15:27 |
rudy1976s |
yes |
| # |
Oct 4th 2018, 15:25 |
ricksaccous |
have you set them up as suggested? |
| # |
Oct 4th 2018, 15:25 |
ricksaccous |
they go over setting up composite key options here https://book.cakephp.org/3.0/en/orm/associations.html#hasmany-associations |
| # |
Oct 4th 2018, 15:23 |
rudy1976s |
keys |
| # |
Oct 4th 2018, 15:23 |
rudy1976s |
unfortunately i have to deal with compiste kets |
| # |
Oct 4th 2018, 15:23 |
rudy1976s |
ah ah |
| # |
Oct 4th 2018, 15:23 |
ricksaccous |
@rudy1976s migrate to a none-composite key, lull |