binding adodb

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

 



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!

[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