Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

problem in check the null condition in query

Anonymous User 4045 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

Anonymous User

Other

I am a content writter !

1 Answers

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>

advertising