I was once mistaken for a woman by a man - I cried for days and would not be consoled until I went out and bought 2 pairs of shoes <g>.
-----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:39 PM To: CF-Talk Subject: Re: Returning columns with null values when specific columns are unknown at runtime 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 >> >> >> > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
