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/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
