mysql in operator

[xwero]

Hello i looked in many fora and on many documentation websites but i can't find a way to use the in operator in a mysql query without having an error.

select name from users where id in (?)

When i parameterize the query like that i get an error saying i don't use the right odbctype. i use int but of course most of the time it's a comma seperated string. If i use the string odbctype i get the same error.

"select name from users where id in ("+ ids+")"

I get what i want but there are occasions where i want to work with those query values, for instance use them in another query, but i can't the only thing i can do is to output them.

i could do a loop of the ids but i want to keep the number of queries as low as possible.

Any light on this problem is very welcome.

[kenobewan]

Have you tried:

"select name from users where id in ('" + ids + "')"

[xwero]

It worked, it's odd because normally you don't need to add a quotation mark inside the round brackets.


Anyway thank you.

[xwero]

Ok back to start. It only gets me the first value.

string mysql = "select name from users where id in ('" + ids + "')";
OdbcCommand com = new OdbcCommand(mysql,conn);
conn.Open();
OdbcDataReader read = com.ExecuteReader();
string names = "";
while(read.Read())
{
    names += read.GetString(0)+"<br>";
}
read.Close();
conn.Close();
 

The names string only holds one name even if the ids string is like 1,2,3

[kenobewan]

Try:

while(read.Read())
{
    names = read.GetString(0);
}

and if that doesn't work just write out read.GetString(0)...

Hope that this helps.