I am having problems figuring out what the difference between two sets of
queries. This query works as I need it to however it is not efficient for the
overall purpose for my page:
<cfquery name="r1" datasource="DB">
Select * From Employees
</cfquery>
<cfset TD="09/30/2006">
<cfloop query="r1">
<cfif DateDiff("yyyy", #r1.Scd#, #DateFormat(TD, "mm/dd/yyyy")#) EQ 20>
<cfoutput>#Name#, #Dob#, #Scd#<br />cfoutput>
</cfif>
</cfloop>
This is the code I have come up with to make it more efficient but does not
select any records. Also, if I change the operator from "= 20" to ">= 20" it
selects all the records in the database...why does that happen too?:
<cfset TD="09/30/2006">
<cfquery name="r1" datasource="DB">
Select * From Employees Where DateDiff('yyyy', #DateFormat(TD, "mm/dd/yyyy")#,
Scd) = 20
<cfloop query="r1">
<cfoutput>#Name#, #Dob#, #Scd#<br /></cfoutput>
</cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2382
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
