Php - odbc Select Where X IN (Select...)

Question

I have the following code

    $stmt = odbc_prepare($conn, 'SELECT tpedidos.*, users.nome FROM tpedidos, users WHERE CODCLI IN (SELECT idCliente FROM ligacoes WHERE idGest =?) AND tpedidos.estado =? AND users.id=tpedidos.CODCLI');
    $success = odbc_execute($stmt, array($gestor, $estado));

My problem is that the $gestor is not being well read in the query and if i put a value instead of the '?' it works.

What can i do?

Thanks in advance!

EDIT 1:

Warning: odbc_execute(): SQL error: [Microsoft][ODBC SQL Server Driver]Syntax error or access violation, SQL state 37000 in SQLDescribeParameter in C:****\file.php on line 720

The function doesnt seem to be able to figure out where $gestor should go — Cacheira, May 18 '17 at 15:09
It puts the parameters into the query in the order the question marks are and the order in the array -- its one for one. — Jeremy Harris, May 18 '17 at 15:11
i know but i guess because the first one is inside () it doesnt get replace. — Cacheira, May 18 '17 at 15:11
Have you tried changing `=?` to `= ?` (note the space)? It may not recognize it correctly because of that. — Jeremy Harris, May 18 '17 at 15:12
Are you getting an error? How do you know it can't figure out where it goes? — Jeremy Harris, May 18 '17 at 15:16
What is the output or exception/error message? Please post fuller PHP code so we can see how *idGest* is assigned. — Parfait, May 18 '17 at 15:16
idGest is a field in the DB and i get the following code on the page *added to post* — Cacheira, May 18 '17 at 15:17
You could also check the sql log to see what is the executed query. My guess is, it is changing the datatype. — hatef, May 18 '17 at 15:21
[here](http://stackoverflow.com/questions/6479107/how-to-enable-mysql-query-log) — hatef, May 18 '17 at 15:28
look i'm doing an infernal intership and i dont have direct access to the logs. — Cacheira, May 18 '17 at 15:40
Is there any other way in sql to query what im looking for, like a substitute for the WHERE CODCLI IN(), because if so i'll just use that — Cacheira, May 18 '17 at 15:41

score 0 · Answer 1 · answered May 18 '17 at 16:00

To reply your last comment regarding an alternative query, you could try with PDO prepared statement:

$sth = $conn->prepare("SELECT tpedidos.*, users.nome 
                          FROM tpedidos, users 
                          WHERE CODCLI IN 
                            (SELECT idCliente FROM ligacoes WHERE idGest = :idGest) 
                          AND tpedidos.estado = :estado 
                          AND users.id = tpedidos.CODCLI");
$sth->bindParam(':idGest', $gestor, PDO::PARAM_INT);
$sth->bindParam(':estado', $estado, PDO::PARAM_STR);
$sth->execute();

P.S: I assumed $estado is a string. If it is an integer replace PDO::PARAM_STR with PDO::PARAM_INT.

Php - odbc Select Where X IN (Select...)

1 Answers1