MySql query using WHERE... IN clauses.

[FranciscoA]

Hello friends.
The following code works for me:

Code: Select all

SELECT vendedor, SUM(gtot) Total_Ventas   FROM facturah
WHERE vendedor IN ( "FRANCISCO","ROBERTO" )  AND fecha BETWEEN '2012-01-01' AND '2012-06-30'
GROUP BY vendedor   ORDER BY vendedor,fecha ;
 

However, I want to automate it by sending a variable with the relevant data:
This does not work. In addition to trying it in many other ways.

Code: Select all

cCad := "FRANCISCO,ROBERTO"  
WHERE vendedor IN ( '"+cCad+"' )  AND fecha BETWEEN '2012-01-01' AND '2012-06-30'
 

It runs without errors, but does not show any results.

Can you tell me what is the right way?
Regards.

[carlos vargas]

Code: Select all

cCad := "FRANCISCO,ROBERTO"  
WHERE vendedor IN ( '"+cCad+"' )  AND fecha BETWEEN '2012-01-01' AND '2012-06-30'
 

se veria asi:

WHERE vendedor IN ( '"FRANCISCO,ROBERTO"' ) AND fecha BETWEEN '2012-01-01' AND '2012-06-30'

y deberia verse asi:

WHERE vendedor IN ( "FRANCISCO","ROBERTO" )  AND fecha BETWEEN '2012-01-01' AND '2012-06-30'

[carlos vargas]

Code: Select all

cCad:=['CARLOS','VARGAS']
WHERE vendedor IN ( "+cCad+" )  AND fecha BETWEEN '2012-01-01' AND '2012-06-30'
 

Code: Select all

?"WHERE vendedor IN (" + cCad+ ") AND fecha BETWEEN '2012-01-01' AND '2012-06-30'"
 

[FranciscoA]

Carlos.
Gracias, ahora ya está funcionando.
Saludos.