Problem with Parameter

[demensys]

I want to use a Parameter in a SQL Statment like:

Code: Select all

SELECT * FROM contracts where `status` in (:Status) order by id desc limit 50;

Status is declaratet as a VarChar.

The Parameter Status is a list off Strings.
This is an Exampel off the SQL Statment without Parameters:

Code: Select all

SELECT * FROM contracts where `status` in ('Eingestellt','Versendet','Kein Interesse') order by id desc limit 50;

The Problem is, that the Execute Statement is:

Code: Select all

SELECT * FROM contracts where `status` in ("'Eingestellt','Versendet','Kein Interesse'") order by id desc limit 50;

Which Parameter Type i must use for this?

Thanks for your Help!

[Alexey]

You cannot use parameters this way. MySQLDirect .NET doesn't support string formatting.

[demensys]

have you an ather way to fix this problem?

[Alexey]

You may perform string formatting yourself. This is the best way to solve the problem.