Re: 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/