!wAdocmGWRyWyWyfGMA:matrix.org

PHP Community Chat

439 Members
👋 Welcome to PHP community chat! 🎉 🐘 This is a social chat channel for the PHP community • This is not a help channel. For help, ask in #php. • https://phpcommunity.org3 Servers

Load older messages


SenderMessageTime
26 Jun 2022
@rcapile[d]:libera.chatrcapile[d] joined the room.17:19:42
@Stratus[d]:libera.chatStratus[d] left the room.17:37:25
@thakidd[d]:libera.chatthakidd[d] left the room.17:49:17
@zPuls3[d]:libera.chatzPuls3[d] left the room.17:52:48
@BobBloom[d]:libera.chatBobBloom[d] joined the room.17:56:44
@illuminatide[d]:libera.chat@illuminatide[d]:libera.chat left the room.18:17:09
@tehjrow[d]:libera.chattehjrow[d] joined the room.18:20:58
@benconda[d]:libera.chatbenconda[d] joined the room.18:44:38
@lobotomised[d]:libera.chatlobotomised[d] joined the room.18:49:42
@BlackScorp[d]:libera.chat@BlackScorp[d]:libera.chat left the room.18:57:10
@adoy[d]:libera.chatadoy[d] joined the room.19:03:59
@thakidd[d]:libera.chatthakidd[d] joined the room.19:05:41
@zPuls3[d]:libera.chatzPuls3[d] joined the room.19:15:28
@ErfanGorgi[d]:libera.chat@ErfanGorgi[d]:libera.chat left the room.19:44:27
@Albright:libera.chatAlbright Pretty sure I've solved this problem in the past but can't remember how. 20:08:05
@Victor[d]:libera.chatVictor[d] joined the room.20:09:11
@ramsey[d]:libera.chat@ramsey[d]:libera.chat left the room.20:13:23
@Crell[d]:libera.chatCrell[d]Relational division is a fugly beast in sql. Avoid it if you can.20:17:46
@Crell[d]:libera.chatCrell[d]I believe you need a sub query (or With clause) that does the join, then filter on that using a Where Not In.20:18:52
@Albright:libera.chatAlbrightWell, I finally found the right magic search engine words to return this: https://stackoverflow.com/a/6613895/1102320:19:51
@Rydian[d]:libera.chat@Rydian[d]:libera.chat left the room.20:32:34
@Flypig07[d]:libera.chat@Flypig07[d]:libera.chat left the room.20:42:24
@ike[d]:libera.chatike[d] joined the room.20:43:00
@chance[d]:libera.chatchance[d] joined the room.20:45:00
@Albright:libera.chatAlbright Yeah, the technique in that SO answer is working for my needs, and it looks familiar enough that I'm fairly sure it's the same approach I used before. 20:47:34
@Albright:libera.chatAlbright For context, I've got an X and several Ys, and Ys can be associated to X, but only once per Y. A I wanted to get a list of Ys which are not already associated with X for creating a "Associate New Y to X" menu. 20:49:07
@Albright:libera.chatAlbright *And I wanted20:49:21
@Stratus[d]:libera.chatStratus[d] joined the room.20:56:11
@bruce[d]:libera.chat@bruce[d]:libera.chat left the room.21:35:49
@russ[d]:libera.chat@russ[d]:libera.chat left the room.22:34:21

There are no newer messages yet.


Back to Room List