Do you mean something like: <CFIF queryname.RecordCount LT 1>
J. John Wilker Web Applications Consultant Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com "With your shield or on it." Spartan mothers would say this to their sons going to battle. It was believed that if you turned to run you'd drop your shield.. If you died in combat your comrades would carry your body home on your shield. So coming home with it or on it were the only options. -----Original Message----- From: Julia Green [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 05, 2002 12:43 PM To: CF-Talk Subject: Re: SQL question Try using RecordCount...Something like if the RecordCount of the type > 1 then don't print or something.... I am not sure exactly how to do it...Dave Watts should know.... Julia Green Julia Computer Consulting PO Box 279 Watertown MA 02471 [EMAIL PROTECTED] http://www.juliagreen.com --- Chad Gray <[EMAIL PROTECTED]> wrote: > I have a table that i would like to pull some information out of. It > looks like this > > ID Type Category Name > 1 a large Foo > 2 a large Foo2 > 3 a large Foo3 > 4 b large Foo4 > 5 b large Foo5 > > What i want to do is grab all the 'large' Category. > > Then i want to display what Type related to all the 'large' Category. > > SELECT * > FROM table > WHERE Category = 'large' > > When i return the results i get > > Type > a > a > a > b > b > > What i want to return is: > > Type > a > b > > > Is there a way to return only a and b and not ALL the a's and b's? > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
