I am trying to use a placeholder does a select with an "in" and am not sure of the correct format.
sqlstmt = 'select * from table where field1 in (?);
and then the placeholder would be
phtest = 'VALUE1','VALUE2';
or
'select * from table where field 1 in ?
phtest = '('VALUE1','VALUE2')';
sqlstmt = 'select * from table where field1 in (?);
and then the placeholder would be
phtest = 'VALUE1','VALUE2';
or
'select * from table where field 1 in ?
phtest = '('VALUE1','VALUE2')';
Comment