Log message #4170271

# At Username Text
# 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
# Oct 4th 2018, 15:21 rudy1976s I also specified bindingKey on the ProductsGroups model association against Attachments
# Oct 4th 2018, 15:18 slackebot contain attachments: : error is "Cannot convert value of type `array` to string" could you please help me a bit ?
# Oct 4th 2018, 15:18 rudy1976s today for the first time I had to deal with composite foreign keys : I found some issue regarding associations: I have a model called ProductsGroups which has a composite foreign key with code and category_id: I need to associate this model to attachments model where the foreign key of the association on attachment model is item_id ( which should store the composite key ? ) I have the following error on a query where I use ProductsGroups
# Oct 4th 2018, 15:14 rudy1976s good afternoon