CodeIgniter Oracle select - random issue - Printable Version +- 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: CodeIgniter Oracle select - random issue (/showthread.php?tid=45132) |
CodeIgniter Oracle select - random issue - El Forum - 09-09-2011 [eluser]Unknown[/eluser] Hello there! I'm having a very weird problem with a quite simple select statement. Here it is: I'm reading a csv file (that is an export of an Excel file). Field separator is ";" and each field is enclosed with "". I use the second, third and fifth fields to create a SELECT to look for that information in the DB. In other words, I'm looking for people in a table according to their last and first names and, email. For example: Code: SELECT MAX(n_id_persona) AS n_id_persona The issue is that, randomly, CodeIgniter does not bring any N_ID_PERSONA but if I test the same query in Oracle SQL Developer it retrieves and ID. I first thought it was a timeout, but is discarded. Also, reformulated the queries because I thought they were not correct but nop. The function NO_ACCENTS() just replaces all accented characters by the corresponding letter and writes everything in uppercase. I also tried without using this NO_ACCENTS() function and got the same weird result. Here it is the code: controllers/importador.php Code: public function __construct() models/importador_model.php Code: function Buscar_contacto($ape = NULL, $nom = NULL, $email = NULL) Any ideas? Does this happen to anyone? Is this a bug? Thanks a lot! V |