This discussion is archived
1 Reply Latest reply: Dec 22, 2012 2:20 PM by 981375 RSS

Query working from sqldeveloper but not from aspx

981375 Newbie
Currently Being Moderated
Hello,

Well Im working on an application that has different queries that involve characters such as áéíóú // ÁÉÍÓÚ // ñÑ. Now the problem is that the query works just fine coming from sqldeveloper or toad but when it's called from an aspx file it returns no rows. Any idea why this might be? It only happens when the query has at least one of the above mentioned characters.

Here you can see an example:
SELECT DISTINCT N_DOCUMENTO FROM PROCESOS_METODOLOGIAS WHERE "LINEA DE NEGOCIO" = 'PRODUCCIÓN' AND N_DOCUMENTO IS NOT NULL ORDER BY N_DOCUMENTO ASC;
I managed to "bypass" it by using LIKE for the time being
SELECT DISTINCT N_DOCUMENTO FROM PROCESOS_METODOLOGIAS WHERE "LINEA DE NEGOCIO" LIKE '%PRODUCCI%' AND N_DOCUMENTO IS NOT NULL ORDER BY N_DOCUMENTO ASC;
But I'm sure there's a solution for that. Any hints would be greatly appreciated.

PS: Query from aspx is made with reference 10g to version 11g on server.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points