Having a bad brain day today.
I am querying a table to check the condition of two fields
(RAPSSubmitted and RAPSRNS). I just need to know if the fields are blank
or not. Actual content is irrelevent.
I need four queries that catch each of the four possibilits (both
populated, both empty, one populated, the other populated)
What I have is this (for example):
<cfquery name="GetRAPSSubmitted" datasource="Encounters">
Select * from tblEncounters
WHERE RAPSSubmitted <> ''
AND RAPSRNS = ''
AND SelectMonth = '#SelectMonth#'
AND SelectYear = '#SelectYear#'
</cfquery>
I have only listed one query for example sake. Bottom line, when I run
all four queries, I do not come up with the total number of records in
the database! Is there a fundamental problem with my technique of
checking the four possibilites here?
TIA,
Tim
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete it from
your system.
This footnote also confirms that this email message has been swept for
the presence of computer viruses.
Thank You,
Viahealth
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197011
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
