Hi, I'm having a problem with iif.
If I do
#iif(qryCustomer.allareas,DE("All
Areas"),DE("#ValueList(qryAreas.name,', ')#"))#
and qryCustomer.allareas is true, therefore qryAreas is undefined (I
check for it with an cfif somewhere else), then I get an error
"Parameter 1 of function ValueList which is now "qryAreas.name" must be
pointing to a valid query name"
If I make it
#iif(qryCustomer.allareas,DE("All Areas"),DE("ValueList(qryAreas.name,',
')"))#
then it works fine in this case, but fails when qryCustomer.allareas is
false as it doesn't evaluate the ValueList(qryAreas.name,', ')
What am I doing wrong?
Russ
______________________________________________________________________
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
