0

Hi,

I have an sqlce query where I dynamically constructs the string by appending different strings. I have a field where I append a product name and its subname. Say for example
main name "Pepsi" and Subname "Large", there are some instance where the Subname is empty and the subname value comes as "null". So when I append the string it will be say

"Pepsi+null" ideally the result should be Pepsi but the sqlce interprets it as "null" and hence my query fails. My data comes from Orcale DB which doesnt support "null", hence even if I want the value as empty, Oracle will return me only null. Any idea why this is happening ? or is there is any solution.

Hope I havent confused you guys!!

-anoop

Edited by anoop4real: n/a

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by anoop4real
0

Show your code where you get and construct the query string, it will make it easier to understand and help you :)

0

Show your code where you get and construct the query string, it will make it easier to understand and help you :)

Hi,

I just put a null check for the subname for the whole query and fixed the problem, but I had to duplicate the code.

-anoop

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.