Don't feel to bad... Walked into an auto-parts supply store to pick up a socket... Had my head shaved and several days growth of hair on my face... Walked up to the counter, girl behind the register looks me dead in the face and says:
"Did you find everything you need mam?" ... Funny thing is, this happens to me perpetually ... not sure why, maybe I was a woman in my last life or something. :) p.s. So what else has changed about your life since the sex change? :) S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > *ahem* he? Damn, who told me about the sex change? I really wish people > would keep me up to date on this stuff. > ----- Original Message ----- > From: "Jesse Houwing" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, September 18, 2002 12:07 PM > 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 >> >> >> > ______________________________________________________________________ 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

