• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.