binding adodb
| From: | Raúl Castro Marín | Date: | Wed, 01 Mar 2006 20:57:00 +0000 |
| Subject: | binding adodb | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-231279@lists.php.net to get a copy of this message | ||
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!