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" <[EMAIL PROTECTED]>
To: "Raúl Castro Marín" <[EMAIL PROTECTED]>
Cc: <php-general@lists.php.net>
Sent: Wednesday, March 01, 2006 7:25 PM
Subject: Re: [PHP] 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
