Oracle DECODE not giving correct results in CF

[mamabird]

I am using CFMX and Oracle 10g.

I am trying to populate a dropdown list from a database using the format "last name, first name". One of the values in the list of users is NA (there is an NA in both the first_name and last_name fields of the database). I don't want the NA record to display as "NA, NA" so I have the following select statement:

SELECT last_name || DECODE(first_name, 'NA', '', ' ,'||first_name) AS name
FROM users

When run in Toad or SQL Plus I get the following result which is what I want:

NA
Grouch, Oscar
Smith, Tom

When I run it from my CF app, the dropdown looks likes this:

NA
Grouch
Oscar
Smith
Tom

It's taking everything following the comma in my default value and putting it on the next line. This is not an Oracle issue as it works in an Oracle tool, but not in CF.

Any ideas?

Thank you!
mamabird

 

[r937]

the problem is your CF code, which we can't see

r937.com | rudy.ca