Always for a single record at a time?
>>-----Original Message----- >>From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] >>Sent: Wednesday, September 18, 2002 10:58 AM >>To: CF-Talk >>Subject: Re: Returning columns with null values when specific columns are >>unknown at runtime >> >>Sorry, but you made the same mistake that simon did. >> >>I don't want to return select * >> >>I want to return select (only columns that are null and I don't know what >>they are up front) where primarykey = some number >> >>I didin't actually have any questions regarding the where statement at >>all. >>I'm aware that I'll probably have to use the whole IS NULL dealie... but >>where I'm stuck is how do I selectively return columns when I don't know >>which columns fit my criteria (containing null values only). >> >>Thanks - Patti >>----- Original Message ----- >>From: "Candace Cottrell" <[EMAIL PROTECTED]> >>To: "CF-Talk" <[EMAIL PROTECTED]> >>Sent: Wednesday, September 18, 2002 11:23 AM >>Subject: Re: Returning columns with null values when specific columns are >>unknown at runtime >> >> >>> How about this.... or am I still missing something >>> >>> Select * from TABLENAME >>> WHERE col1 IS NULL OR col2 IS NULL OR col3 IS NULL OR col4 IS NULL >>> >>> >>> Candace K. Cottrell, Web Developer >>> The Children's Medical Center >>> One Children's Plaza >>> Dayton, OH 45404 >>> 937-641-4293 >>> http://www.childrensdayton.org >>> >>> >>> [EMAIL PROTECTED] >>> >>> >>> [EMAIL PROTECTED] 9/18/2002 11:17:41 AM >>> >>> Thanks, but that doesn't get me where I want. >>> >>> I ONLY want to return the columns that ARE null, and I never know which >>> ones >>> those are when I run this query... so what I need is something for the >>> select statement. >>> >>> -Patti >>> ----- Original Message ----- >>> >>> > The only thing I can think to do is create a bunch of OR statements >>> i.e.: >>> > WHERE colA IS NULL OR colB IS NULL OR colN IS NULL >>> > >>> > ~Simon >>> > >>> > >>> > -----Original Message----- >>> > >>> > >>> > Is there a way to write a MSSQL 2k query that will return a result >>> set >>> that >>> > contains only columns with null values when you don't know >>> explicitly >>> which >>> > columns those will be? >>> > >>> > So if I have this data >>> > >>> > pk | col 1 | col 2 | col 3 | col 4| >>> > 1 1 2 null null >>> > 2 null 4 null null >>> > >>> > I'd like a query that would return col 3 and col 4 where pk = 1 or >>> col 1, >>> > col 3 and col 4 where pk=2. >>> > >>> > Is this possible? >>> > -Patti >>> >>> >>> >>> >> ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
