Hi all,
I am new to ColdFusion and just took over an application that was built several
years ago. As I am learning coldfusion one of the things I have been tasked
with doing is limiting the results returned by the query to the current year
minus 1. For instance we are currently in year 2013 so documents will only be
retrieved for 2013 and 2012. As you can see below the the query
"getuserdocuments" returns all documents, is there a way to limit the result
based on the criteria i stated above?
Thanks in advance for your help, Lorenzo
<cfset noRecBgColor="Yellow">
<cfobject component="hbcfc.document" name="Documents">
<cfinvoke component="#Documents#" method="getUserDocuments"
returnvariable="getUserDocuments">
<cfinvokeargument name="cfcUserUserID" value="#AppLogon_name#">
</cfinvoke>
<!---Header needs to be included in every file --->
<cfinclude template="header.cfm">
<h3><cfoutput> #AppTitle#<br>
</cfoutput><span style="font-weight: bold"><img src="ekg.gif" width="198"
height="76"></span></h3>
<cfform name="DocList">
<ul>
<li style="font-weight: bold">HeartBeat Documents </li>
<ul>
<cfoutput query="getUserDocuments" >
<cfobject component="hbcfc.document" name="Documents2">
<cfinvoke component="#Documents2#"
method="getDocumentsViewOrEdit" returnvariable="ViewOrEdit">
<cfinvokeargument name="cfcUserUserID" value="#AppLogon_name#">
<cfinvokeargument name="cfcDocID"
value="#getUserDocuments.DocID#">
</cfinvoke>
<li><span style="font-weight: bold"><a
href="#getUserDocuments.DocType#_<cfif ViewOrEdit is
"Locked">View<cfelse>#ViewOrEdit#</cfif>.cfm?DocID=#getUserDocuments.DocID#">
#getUserDocuments.DocType# - #getUserDocuments.DocTitle#</a></span>
<font color="green" size="-2">#getUserDocuments.DocFiscalYear#
(#ViewOrEdit#<cfif ViewOrEdit IS "Edit">/Approve</cfif>)</font></li><br>
</cfoutput>
.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:6045
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
