Re: binding adodb

Hello I could resolve the problem, I'm rewrote query: $query = "SELECT munici_mun, UPPER(nombre_mun)

               FROM MUNI
               WHERE departa_dpt = ?
                AND munici_mun <= 994
                 AND UPPER(nombre_mun) LIKE ?"

then I only change the variable definition like: $bind[] = '%'.$key.'%'; thanks ----- Original Message ----- From: "Chris" <dmagick@gmail.com> To: "Raúl Castro Marín" <raul.castro@cdmb.gov.co> Cc: <php-general@lists.php.net> Sent: Wednesday, March 01, 2006 7:25 PM Subject: Re: [PHP] binding adodb

Raúl Castro Marín wrote:

I got a little question, I just start to use binding adodb but I got a problem: my primary query on Oracle is: $query = "SELECT munici_mun, UPPER(nombre_mun) FROM MUNI WHERE departa_dpt = ? AND munici_mun <= 994"; It is execute with any problem, but when I add another clause with keyword: AND UPPER(nombre_mun) LIKE '%?%' then next sentence is execute but no record is returned $query = "SELECT munici_mun, UPPER(nombre_mun) FROM MUNI WHERE departa_dpt = ? AND munici_mun <= 994 AND UPPER(nombre_mun) LIKE '%?%' I think that adodbd doesn't parse "?" like a variable on clause LIKE '%?%'. What can I do to write this sentence correctly? thanks for your help!

Hi, You might get a quicker response on their mailing list: http://adodb.sourceforge.net/#mail It might not pick it up because it's in quotes but they will be able to tell you for sure. -- Postgresql & php tutorials http://www.designmagick.com/ ------=neXtPaRt_1141258927 Content-Type: text/plain; Este correo se ha verificado por el Firewall de la CDMB ------=neXtPaRt_1141258927--