
Tag: Logic
MySQL Query faster alternative to DISTINCT and REGEXP
You might get faster performance using FIND_IN_SET and a couple of joins: SELECT DISTINCT locations.* FROM locations INNER JOIN users users_include ON users_include.user_id = 1 AND FIND_IN_SET(users_include.user_locations, locations.combined_locations) > 0…
Simple 17 Step Sequence | Patchstorage
I was helping Riley Taylor in the VCV Community develop a crude emulator of the Teenage Engineering Endless Sequencer feature. community.vcvrack.com/t/op-1s-endless-sequencer-in-vcv-rack/19019 I was playing around with the result, and stumbled…
Frame rendering will include files outside of intended frame range when using the same file name.
bugs.kde.org/show_bug.cgi?id=443105 — Comment #7 from Eoin O’Neill <eoinoneill1…@gmail.com> — Git commit ebe74faf98c4b0ba5607e99596f64dcbfaeaf6a3 by Eoin O’Neill. Committed on 28/07/2022 at 20:49. Pushed by eoinoneill into branch ‘cherry-pick-c290356a’. Improve logic for cleaning…
XSLT XML to JSON issue
First, you don’t say what version of XSLT you want to use, so here is an XSLT 3.0 solution: <xsl:stylesheet version=”3.0″ xmlns:xs=”http://www.w3.org/2001/XMLSchema” xmlns:xsl=”http://www.w3.org/1999/XSL/Transform”> <xsl:output method=”json” indent=”yes”/> <xsl:strip-space elements=”*”/> <xsl:template match=”/r”>…