B4J Question IN clause jrdc2 server

aeric said:

You will need 2 question marks inside the bracket after the IN.

B4X:

sql.filterGymsCount = SELECT COUNT(*) FROM gyms g JOIN gymTypes gt ON g.id = gt.id_gym JOIN types t ON gt.id_type = t.id WHERE t.name IN (?, ?) GROUP BY g.id HAVING COUNT(DISTINCT t.name) = ?

Click to expand...

        Private parameter As String

        For Each v As String In mapFilter.Values
            parameter = parameter & "," & v
        Next
    
        gymsCount(parameter.SubString(1))

        Private parameters As String

        For Each v As String In mapFilter.Values
            parameters = parameters & ",'" & v & "'"
        Next
    
        gymsCount(parameters.SubString(1))

jahswant said:

I USE THIS

B4X:

SELECT * FROM classe WHERE FIND_IN_SET(classe_id,?);

YOU CAN SEND '1,2,3,4,5,6,7,7,9,10' YOU DON' T NEED IT TO BE LIKE (1,2,3,4,5,6,7,7,9,10).

THIS CODE WILL WORK ON MYSQL.

Click to expand...

SELECT COUNT(*)
FROM (
    SELECT
        g.id
    FROM
        gyms g
    JOIN
        gymTypes gt ON g.id = gt.id_gym
    JOIN
        types t ON gt.id_type = t.id
    WHERE
        FIND_IN_SET(t.name, 'Crossfit,HYROX,Yoga') > 0
    GROUP BY
        g.id
    HAVING
        COUNT(DISTINCT t.name) = 3
) AS subquery