Zoomed Image

AMSX Scripting Language - Command : SqlInList

Summary

Store a comma-separated list as a SQL-safe IN list variable

Description

Marks the value as a SQL-safe IN list so it can be embedded in a SQL "WHERE x IN (...)" clause without injection risk. SqlInListQuoted wraps each item in single quotes. Must be used with variable assignment. Throws if not assigned to a variable.

Parameters

ParameterDescription
cmdComma-separated list of values for the IN clause

Syntax


SqlInList "Comma-separated list of values for the IN clause"

Return to the AMSX Command Reference