topic-37876

Posts: 2170

Joined: Fri Jul 18, 2008 01:24 AM

MySql query using WHERE... IN clauses.
Posted: Thu Oct 10, 2019 08:12 PM

Hello friends.
The following code works for me:

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 (fw): Select all Collapse

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.

Francisco J. Alegría P.

Chinandega, Nicaragua.

Fwxh-MySql-TMySql

carlos vargas

Posts: 1789

Joined: Tue Oct 11, 2005 05:01 PM

Re: MySql query using WHERE... IN clauses.
Posted: Thu Oct 10, 2019 08:27 PM

Code (fw): Select all Collapse

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'

Salu2

Carlos Vargas

Desde Managua, Nicaragua (CA)

carlos vargas

Posts: 1789

Joined: Tue Oct 11, 2005 05:01 PM

Re: MySql query using WHERE... IN clauses.
Posted: Thu Oct 10, 2019 08:31 PM

Code (fw): Select all Collapse

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

Code (fw): Select all Collapse

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

Salu2

Carlos Vargas

Desde Managua, Nicaragua (CA)

FranciscoA

Posts: 2170

Joined: Fri Jul 18, 2008 01:24 AM

Re: MySql query using WHERE... IN clauses.
Posted: Thu Oct 10, 2019 09:33 PM

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

Francisco J. Alegría P.

Chinandega, Nicaragua.

Fwxh-MySql-TMySql

FiveTech Support Forums

Continue the discussion