>From Dwayne: "ValueList returns a "comma-separated list" from a query object. So ClientID should be column in the query object GetRW."
Yes, I got that part. What I was doing was trying to use <CFIF #ListLen(ValueList(GetRW.ClientID))#> to check for data in the list. But I got an error instead that referred to that line. (Sorry, I changed the code and can't remember exactly what the error was) When I changed it to <CFIF #ListLen(GetRW.ClientID))#> to check for data in the list, it worked fine. Seems like both should have worked...? Rick -----Original Message----- From: Dwayne Cole [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 7:19 PM To: CF-Talk Subject: Re: Why does one work, but not the other? >Why does this expression work: > > <CFIF #ListLen(GetRW.ClientID)#> > >But this one doesn't: > > <CFIF #ListLen(ValueList(GetRW.ClientID))#> > ======================================== ValueList returns a "comma-separated list" from a query object. So ClientID should be column in the query object GetRW. Dwayne Cole, MS in MIS, MBA Florida A&M University Certified Advanced ColdFusion Developer 850-591-0212 "It can truely be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all "sound and fury, signifiying nothing." The Fifth Discipline - Peter Senge > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
