Welcome Guest, Not a member yet? Register   Sign In
ODBC memo field
#1

[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..

#2

[eluser]KaMiii[/eluser]
got it working, reminded a solution

Regards,

//CLOSE




Theme © iAndrew 2016 - Forum software by © MyBB