Parameterize "WHERE IN([x]) ..." query syntax

[Lumine]

Hi,

I'm trying to query external data from an access database and trying to parameterize the IN() part of the where statement and I can't seem to get the syntax right.

I am not sure if it is a part of the syntax of the sql or the syntax of my inputs. My sql reads:

SELECT column_name
FROM table_name
WHERE column_name IN (?)

I've tried inputs like the following

input1,input2
'input1','input2'
('input1','input2')
input1                       <-- the only one that works

Any thoughts? I can't seem to get this guy working

 

[Fazza]

you write that the only one that works is : input1

some thoughts. I think the syntax will be input1 if the field contains numeric entries; if it contains text, I'd expect 'input1'

therefore you have numeric entries?

for multiple numeric entries, try : IN (input1, input2, input3, etc)

OK?

 

[RoryA]

You can't use one parameter to build a multi-value IN clause. The whole parameter is treated as one element in the In clause.