[eluser]KaMiii[/eluser]
Hi, i need some help with an odbc query to acess, i've done a lot of querys.. and everything went good till now,
Made some queries to memo field, but since it was a one time query only it was ok..
now thinkgs got complicated, i need to query multiple memo fields in the same product
$bens_ap = odbc_exec($conn, "SELECT * FROM ProcessosDetalhe WHERE IDProcesso = '$numero_processo' AND Eliminado = 0 ") or die (odbc_errormsg());
Here is the query, it got 2 results in it..
tried this
while(odbc_fetch_array($bens_ap)) {
$ap_ident= odbc_result($bens_ap,"Identificacao");
$ap_valor= odbc_result($bens_ap,"Valor");
$ap_desc= odbc_result($bens_ap,"Descricao");
}
But it gives me the invalid cursor pointer error
Need some help here,
Regards..