Patti, One thing you've got to keep in mind is that if your query finds NULLs in 100 rows and amongst those 100 rows there is at least one instance of a NULL value in each of your 26 columns, you WILL get back all columns for all rows. Just want to make sure you're clear on that.
~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -----Original Message----- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:58 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
