Sean,
Hi! Did you try this solution that I proposed :
SELECT person.name FROM person, class, link WHERE
link.pid=person.id AND link.cid=class.id AND class.name IN ('A', 'B')
GROUP BY person.name
HAVING count(*) = 2
So if you wanted to search across 3 classes, you'd write :
SELECT person.name FROM person, class, link WHERE
link.pid=person.id AND link.cid=class.id AND class.name IN ('A', 'B', 'C')
GROUP BY person.name
HAVING count(*) = 3
Regards,
Narinder.
> Hello all. I inadvertently sent some of my replies on Friday to
> individuals and not back to the nug. Whoops. Thanks for all of the
> replies. I've gotten some great help from the nug. I've learned a few
> cool things, but I haven't yet figured out my original problem.
>
> Here's the situation:
>
<snip>
> What I'm still after is only students in a specific set of classes.
> For example - A & B. (A recordset containing only Narinder and Norman
> is what i'd want - They are the only two students who are in both
> classes A & B) I've tried various forms of GROUP BY and COUNT, but I
> haven't been able to get any results.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
From Mon 31 Jul 2006 19:11:28 +0200
Return-Path: <realbasic-nug-bounces at lists dot realsoftware dot com>
X-Original-To: listarchive at realsoftware dot com
Delivered-To: listarchive at realsoftware dot com
Received: by xmail.realsoftware.com (Postfix, from userid 1037)
id 871A78F36C0; Mon, 31 Jul 2006 10:11:57 -0700 (PDT)
X-Spam-Checker-Version: SpamAssassin 3.1.1 (2006-03-10) on realxserve.local
X-Spam-Level:
X-Spam-Status: No, score=-2.5 required=4.5 tests=AWL,BAYES_00 autolearn=ham
version=3.1.1
Received: from lists.realsoftware.com (lists.realsoftware.com [209.198.132.125])
by xmail.realsoftware.com (Postfix) with ESMTP id 221928F36B6;
Mon, 31 Jul 2006 10:11:52 -0700 (PDT)
Received: from lists.realsoftware.com (localhost [127.0.0.1])
by lists.realsoftware.com (Postfix) with ESMTP
id 22AE813E695D; Mon, 31 Jul 2006 12:11:36 -0500 (CDT)
X-Original-To: realbasic-nug at lists dot realsoftware dot com
Delivered-To: realbasic-nug at lists dot realsoftware dot com
Received: from smtprelay01.ispgateway.de (smtprelay01.ispgateway.de
[80.67.18.13])
by lists.realsoftware.com (Postfix) with ESMTP id 6061D13E694E
for <realbasic-nug at lists dot realsoftware dot com>;
Mon, 31 Jul 2006 12:11:29 -0500 (CDT)
Received: (qmail 6875 invoked from network); 31 Jul 2006 17:11:28 -0000
Received: from unknown (HELO [192.168.1.80]) (363246 at [84 dot 175 dot 118 dot
38])
(envelope-sender <support at monkeybreadsoftware dot de>)
by smtprelay01.ispgateway.de (qmail-ldap-1.03) with SMTP
for <realbasic-nug at lists dot realsoftware dot com>; 31 Jul 2006
17:11:28 -0000
To: realbasic-nug at lists dot realsoftware dot com (REALbasic NUG)
In-Reply-To: <p0602040ec0f3dd388297 at [192 dot 168 dot 0 dot 18]>
From: support at monkeybreadsoftware dot de (Christian Schmitz)
Date: Mon, 31 Jul 2006 19:11:28 +0200
Message-ID: <1hjct93 dot 1k4r70x11d4ymiM%support at monkeybreadsoftware dot de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Organization: Monkeybread Software Germany
X-Face: nrf3>{WQ6c&r+7 at e)"]0G60`-6ND^)I2mI%>)QGYa=9"=7jhd-g2|b3!>Al0+
Ccb%xGQshhi|g at QU2$
User-Agent: MacSOUP/D-2.7 (Mac OS X version 10.4.7)
Subject: Re: MBS Plugin - Quicktime Movie glitch/pause in playback under
Windows
X-BeenThere: realbasic-nug at lists dot realsoftware dot com
X-Mailman-Version: 2.1.2
Precedence: list
Reply-To: REALbasic NUG <realbasic-nug at lists dot realsoftware dot com>
Sender: realbasic-nug-bounces at lists dot realsoftware dot com
Errors-To: realbasic-nug-bounces at lists dot realsoftware dot com
Chris Smolinski <csmolinski at blackcatsystems dot com> wrote:
> I also have a thread that runs every 100 msec which calls it for any
> sounds playing,
Better 50ms and just once, not for each sound file.
> What is curious is that he reports the glitch always happens between=20
> 2:30 and 2:48 into the sound file, I am sure that is significant, but
> I'm not sure what it means! :-)=20
Maybe at that point QuickTime is loading more data.
The problem is often also that Timers do not fire always.
So while you do a long computation the app is blocked for some time and
the sound buffers run emtpy.
Gru=DF
Christian
--=20
Around eleven thousand functions in one REALbasic plug-in.=20
The Monkeybread Software Realbasic Plugin v6.2.
<http://www.monkeybreadsoftware.de/realbasic/plugins.shtml>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|