Valuelist()

Returns a list of all the values, for a given column within the query, delimited by the value given

Usage

STRING = Valuelist(
				
					
					
						column, 
					
				
					
					
						delimiter, 
					
				
					
					
						defaultreturn
					
				
				)

Argument	Summary
column	query.column
delimiter	value separator. defaults to comma (,) [optional]
defaultreturn	if there are no rows, this is the default value return; blank [optional]

Calling

Supports named-parameter calling allowing you to use the function like:

Valuelist(
   column=?, 
   delimiter=?, 
   defaultreturn=?
);

Supports passing parameters as a structure using ArgumentCollection:

Valuelist( ArgumentCollection={
   column : ?, 
   delimiter : ?, 
   defaultreturn : ?
} );

Valuelist()

Usage

Calling

See Also