Re: binding adodb

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, 2006-03-01 at 19:25, Chris wrote:
> 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?

Does it return anything if you run it directly against the DB?



-- 

s/:-[(/]/:-)/g


Brian        GnuPG -> KeyID: 0x04A4F0DC | Key Server: pgp.mit.edu
======================================================================
gpg --keyserver pgp.mit.edu --recv-keys 04A4F0DC
Key Info: http://gfx-design.com/keys
Linux Registered User #339825 at http://counter.li.org

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux