forum

Home / DeveloperSection / Forums / problem in check the null condition in query

Ask Question

problem in check the null condition in query

Anonymous User 3349 14-Jan-2011
This is the code

SELECT query1.field1, query1.field2, query1.field3
FROM query1
WHERE field1 not in (#QuotedValueList(query2.field1)#)

I need to change that "WHERE" line to make this query run even if query2 is
null. It currently doesn't work if query2 is null.

how it is solve it give the solution of its problem in check the null condition in query
cold fusion cold fusion 
Updated on 17-Jan-2011
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

17-Jan-2011
check the null condition in query2 field we apply the if condition and check the record count of that field

SELECT query1.field1, query1.field2, query1.field3
FROM query1
<CFIF query2.RecordCount IS NOT 0>
WHERE field1 not in (#QuotedValueList(query2.field1)#)
</CFIF>

Liked By