Ask a Question related to Coldfusion Database Access, Design and Development.
-
T McDizzle #1
Check for null query
I have some code something like this in a query of a query:
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. I was thinking an OR
statement would be needed, I just don't know what to put in it. Any help would
be appreciated. Thanks.
T McDizzle Guest
-
Getting a 'Null Pointers' error when using query ofQueries
Hi, I am using text in a file to create a new query. This section works correctly. I am then using query of Queries:- <cfquery... -
how to to check array Null value on coldfusion 7
Hi, How do you check the array elements empty or not. for example, I have array - array , and from array to array has some value, and there... -
CGI.pm form query sometime return null value
I am using CGI.pm, and getting the parameters similiar to the followings, use CGI::Carp qw(fatalsToBrowser); use CGI qw(:all); : my $task =... -
Question: How check if datareader is null?
"VB Programmer" <growNO-SPAM@go-intech.com> wrote in message news:eGmnp2MYDHA.1784@TK2MSFTNGP09.phx.gbl... If Not (drReader Is Nothing) Then ...... -
Check for Null In Conditional Formating
Try the expression: IsNull() -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users -... -
-
jdeline #3 Re: Check for null query
Maybe something like the code below would work.
SELECT query1.field1, query1.field2, query1.field3
FROM query1
<CFIF query2.RecordCount IS NOT 0>
WHERE field1 not in (#QuotedValueList(query2.field1)#)
</CFIF>
jdeline Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
