valueList?

kt03 wrote: <cfset emailList = ValueList(qry.email ,  ',' /> but i am getting an error "Complex construct are not supported with fuction ValueList."  and i am not sure if i am going to the right direction?

That line misses a closing bracket.

The purpose of the ValueList() function is to take values in a field from multiple records in the record set and make a list out of them.  Which, if you had a well normalize database design, you would be retreiving.

I.E. qry_email

<cfoutput>#valueList(qry_email.email)#</cfoutput>

will return "test@abc.com,foobar@one.org,joe@nodbody.net".

You have a un-normalized table field that contains a list of values.  I presume you would like to process the items in that list individually.

The list functions are probably what you would like to use.

I.E.

<cfloop list="#qry_email.email#" item="x">

<cfoutput>#x#</cfoutput>

</cfloop>

There are many other list functions you can use, listFirst(), listLast(), listGetAt(), etc.

Of course the professional in me would suggest that you properly normaize your database design if at all possible.

I presume there's a typo in your code there because that would not compile as is.

What's the value of qry.email?

--

Adam