Coldfusion check is null

So, when I said "looping" I meant that that is the situation in which this mostly comes up; I didn't mean to say that that is how Java performs loops in general. Sorry for the confusion. The same behavior deleting the variable is also exhibited iif you have the following within a cffunction:. The return type of the function needs to be "Any" or "Void" - but it it was void, then there would be no need to check it.

Hi Ben! I have a CF-Java codes not written by me, I don't speak java that converts a text feed into a query. All I need to do is to query this query and use the resultset. Unfortunately this java things create difficulty on my simple query may be it is related to what you wrote in this blog about java returning null instead of empty string?

What you are running into is one of the many times that ColdFusion query of queries become frustrating. Try casting the SSN and bday back to varchar:. I haven't been on CFMX in a long time.

Perhaps you can try calling a Java method that returns a NULL value and pass that to the constructor. Sorry I don't have any better advice. Light Dark. Asked 7 years, 9 months ago. Active 7 years, 9 months ago. Viewed 4k times. Improve this question. Henry Johnny Oshika Johnny Oshika Add a comment. Active Oldest Votes.

Improve this answer. Henry Henry Although it's painful as is most things in ColdFusion , it seems like this is the best way in CF How are you posting this data? What do you get when you dump just the variable "json"? Adrian J. Moreno Adrian J.

Moreno I'm working with JSON, so it won't be form scoped. This is what I have tried and it failed. Can anyone tell me a better way? You can use your database's ifNull or the like. However, in ColdFusion, queries are returned as strings. Given your situation, easiest way is to check for a non-empty string:. By the way, you don't need the pound signs inside of an evaluation: only when using a variable as a literal such as when outputting. The method of grabbing all the student table records will work great when you have or so students.

What happens when it is put into production and there are 25, students? While the java class of CFQuery object coldfusion. QueryTable will return empty string for any null value, it's parent class coldfusion. Table is providing a method getField row, column to access the query table values directly, which return "undefined" if the value is null. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. How to check for a null value from the return value in ColdFusion query loop Ask Question.