Well, is the paid field a character field or a number field in the DB? and just FYI, you can always go #querryName.Recordcount# to get a count via CF. :)
On Tue, Jun 17, 2008 at 3:23 PM, Jessica Kennedy <[EMAIL PROTECTED]> wrote: > I'm pretty sure I will smack my head when I hear the answer, but I'll ask > anyway... > > I am using a select count() query to get the number of people directly > sponsored by a person... this works fine, the problem is that I only want to > have the query count people that meet a certain qualification. There has to > be a simple way to do this, my query pretty much looks like this: > > SELECT COUNT(node.name) > FROM tbl1 as node, tbl1 as parent > WHERE parent.sponsor=node.name AND node.paid='yes' > GROUP BY node.name > > the "AND node.paid='yes'" seems to be doing nothing... I'm pretty sure I'm > missing something really simple, help! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307632 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
