As I told Patti off-list, this could be done with a cursor. That said, I hazard to guess that whatever database solution you find that does JUST return the data she's looking for, it won't offer much (if any) performance advantage over parsing things out manually.
~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: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 12:08 To: CF-Talk Subject: Re: Returning columns with null values when specific columns are unknown at runtime Candace Cottrell wrote: > 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 I think he wants the names of the colums that have null values as a result. Though I have no idea how to do that, or what he would like to use it for Jesse ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
