Reply to thread

Message

<blockquote data-quote="MausWiesel" data-source="post: 1209637" data-attributes="member: 117562">Soeben gestest (sowohl 2 Sendergruppen - &quot;All Channels&quot; + &quot;Kabel&quot; - als auch mit nur 1 Sendergruppe - &quot;All Channels&quot;) und den MySQL-Teil für funktionsfähig erklärt.Wie geht es weiter? Es waren so Stichworte wie Option &quot;Use All Channels&quot; oder auch Vereinheitlichen der DB-Zugriffe/Funktionalitäten genannt.Aktuell sieht es in Bezug auf die DB-Anbindungen in rein verinfachter Form ja so aus:SQLite:SELECT groupmap.idGroup, groupmap.idChannel, channel.displayName FROM groupmap INNER JOIN channelgroup on groupmap.idGroup = channelgroup.idGroup INNER JOIN channel On&nbsp; groupmap.idChannel = channel.idChannel WHERE channelgroup.groupName NOT LIKE &quot;All Channels&quot; ORDER BY UPPER(channel.displayName) --&gt; Array&nbsp;Array.Rows = 1?&nbsp;SELECT groupmap.idGroup, groupmap.idChannel, channel.displayName FROM groupmap INNER JOIN channelgroup on groupmap.idGroup = channelgroup.idGroup INNER JOIN channel On&nbsp; groupmap.idChannel = channel.idChannel ORDER BY UPPER(channel.displayName) --&gt; Array------------------------------------------------------------------------------MySQL:SELECT COUNT(*) FROM channelgroup --&gt; ChanGroupCount&nbsp;ChanGroupCount &lt; 1?--&gt; Logfile + Exit ChanGroupCount &gt; 1?SELECT groupmap.idGroup, groupmap.idChannel, channel.displayName FROM groupmap INNER JOIN channelgroup on groupmap.idGroup = channelgroup.idGroup INNER JOIN channel On&nbsp; groupmap.idChannel = channel.idChannel WHERE channelgroup.groupName NOT LIKE &quot;All Channels&quot; ORDER BY UPPER(channel.displayName) --&gt; Array&nbsp;ChanGroupCount = 1?&nbsp;SELECT groupmap.idGroup, groupmap.idChannel, channel.displayName FROM groupmap INNER JOIN channelgroup on groupmap.idGroup = channelgroup.idGroup INNER JOIN channel On&nbsp; groupmap.idChannel = channel.idChannel ORDER BY UPPER(channel.displayName) --&gt; Array------------------------------------------------------------------------------MSSQL:SELECT groupmap.idGroup, groupmap.idChannel, channel.displayName FROM groupmap INNER JOIN channelgroup on groupmap.idGroup = channelgroup.idGroup INNER JOIN channel On groupmap.idChannel = channel.idChannel WHERE channelgroup.groupName NOT LIKE 'All Channels' ORDER BY UPPER(channel.displayName) --&gt; Array&nbsp;Array.Rows &lt; 2?&nbsp;SELECT groupmap.idGroup, groupmap.idChannel, channel.displayName FROM groupmap INNER JOIN channelgroup on groupmap.idGroup = channelgroup.idGroup INNER JOIN channel On groupmap.idChannel = channel.idChannel ORDER BY UPPER(channel.displayName) --&gt; Array</blockquote>

[QUOTE="MausWiesel, post: 1209637, member: 117562"] Soeben gestest (sowohl 2 Sendergruppen - "All Channels" + "Kabel" - als auch mit nur 1 Sendergruppe - "All Channels") und den MySQL-Teil für funktionsfähig erklärt. Wie geht es weiter? Es waren so Stichworte wie Option "Use All Channels" oder auch Vereinheitlichen der DB-Zugriffe/Funktionalitäten genannt. Aktuell sieht es in Bezug auf die DB-Anbindungen in rein verinfachter Form ja so aus: [U][B]SQLite:[/B][/U] [I]SELECT groupmap.idGroup, groupmap.idChannel, channel.displayName FROM groupmap INNER JOIN channelgroup on groupmap.idGroup = channelgroup.idGroup INNER JOIN channel On groupmap.idChannel = channel.idChannel WHERE channelgroup.groupName NOT LIKE "All Channels" ORDER BY UPPER(channel.displayName) --> Array Array.Rows = 1? [/I] [INDENT][I]SELECT groupmap.idGroup, groupmap.idChannel, channel.displayName FROM groupmap INNER JOIN channelgroup on groupmap.idGroup = channelgroup.idGroup INNER JOIN channel On groupmap.idChannel = channel.idChannel ORDER BY UPPER(channel.displayName) --> Array[/I][/INDENT] ------------------------------------------------------------------------------ [B][U]MySQL:[/U][/B] [I]SELECT COUNT(*) FROM channelgroup --> ChanGroupCount ChanGroupCount < 1?[/I] [INDENT][I]--> Logfile + Exit[/I][/INDENT] [I] ChanGroupCount > 1?[/I] [INDENT][I]SELECT groupmap.idGroup, groupmap.idChannel, channel.displayName FROM groupmap INNER JOIN channelgroup on groupmap.idGroup = channelgroup.idGroup INNER JOIN channel On groupmap.idChannel = channel.idChannel WHERE channelgroup.groupName NOT LIKE "All Channels" ORDER BY UPPER(channel.displayName) --> Array[/I][/INDENT] [I] ChanGroupCount = 1? [/I] [INDENT][I]SELECT groupmap.idGroup, groupmap.idChannel, channel.displayName FROM groupmap INNER JOIN channelgroup on groupmap.idGroup = channelgroup.idGroup INNER JOIN channel On groupmap.idChannel = channel.idChannel ORDER BY UPPER(channel.displayName) --> Array[/I][/INDENT] ------------------------------------------------------------------------------ [U][B]MSSQL:[/B][/U] [I]SELECT groupmap.idGroup, groupmap.idChannel, channel.displayName FROM groupmap INNER JOIN channelgroup on groupmap.idGroup = channelgroup.idGroup INNER JOIN channel On groupmap.idChannel = channel.idChannel WHERE channelgroup.groupName NOT LIKE 'All Channels' ORDER BY UPPER(channel.displayName) --> Array Array.Rows < 2? [/I] [INDENT][I]SELECT groupmap.idGroup, groupmap.idChannel, channel.displayName FROM groupmap INNER JOIN channelgroup on groupmap.idGroup = channelgroup.idGroup INNER JOIN channel On groupmap.idChannel = channel.idChannel ORDER BY UPPER(channel.displayName) --> Array[/I][/INDENT] [/QUOTE]

Verification