Re: binding adodb

[Raúl Castro Marín <raul.castro@xxxxxxxxxxx>]

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@xxxxxxxxx>
To: "Raúl Castro Marín" <raul.castro@xxxxxxxxxxx>
Cc: <php-general@xxxxxxxxxxxxx>
Sent: Wednesday, March 01, 2006 7:25 PM
Subject: Re:  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-- 

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php