You can change the delimiters to whatever you want to, but yeah it defaults
to comma's
#valuelist(queryname.columnName,"||")#
would give you:"[EMAIL PROTECTED]||[EMAIL PROTECTED]||[EMAIL PROTECTED]||etc.
#valuelist(queryname.columnName,",")# or #valuelist(queryname.columnName)#
would give you:"
> I am a little unsure of the way this function works ... does it
> result in a
> comma delimited string purely?
>
> eg., if I alter a column from a query like
>
>
>
> Assuming there are say 5 email addresses in this result/email column...
> could I use #emailto# in the "To:" field of a email as
That is correct, except no spaces after the commas. You also have
quotedValueList() which will give you the same list but with single quotes
around it.
hth,
Jason
Web Application Developer
webworld studios, inc.
-Original Message-
From: PC [mailto:[EMAIL PROTECTED]]
Sent: Saturday, Augu
3 matches
Mail list logo