Description
Similar to the DBLOOKUP function, except that it returns all matching values as a comma delimited string.
Syntax
DBLOOKUPLIST ( SourceField, "connection", "table", "lookup_field", "substitution_field" )
| Parameter | Description |
|---|---|
| SourceField | The value for which to search in the lookup_field column. |
| connection | The connection where this lookup table resides. If the connection is Scribe Internal Database, the SCRIBE user must have at least SELECT privileges on the lookup table.. |
| table | The name of the lookup table. |
| lookup_field | The name of the column in the lookup table that stores the value to search for. |
| substitution_field | The name of the column in the lookup table that stores the value to return. |
Remarks
Note: This function requires special handling when working with bulk operations. See Using Bulk Operations for more information.
Use this function with Lookup Links and the "IN" operator.
This function works only with databases or adapters that support SQL queries.
See also