Nick - Can you please confirm -
- In what format, you have date in Database in column Scd?
- What you get when you simply select
" DateDiff('yyyy', #DateFormat(TD, "mm/dd/yyyy")#, Scd) " as a field
name without using it as a filter?
Thanks.
-Sandy Vohra
-----Original Message-----
From: Nick G [mailto:[EMAIL PROTECTED]
Sent: Friday, December 29, 2006 10:53 AM
To: CF-Newbie
Subject: CF Query Select Strings
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:2383
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
