+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: ODBC memo field (/showthread.php?tid=54930)
ODBC memo field - El Forum - 10-02-2012
[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..
ODBC memo field - El Forum - 10-02-2012
[eluser]KaMiii[/eluser]
got it working, reminded a solution
Regards,
//CLOSE