I'm trying to compare dates in my SQL statement. I can compare month and
year, but not day. Here is my query.
<cfquery name="getTicketCount" datasource="#request.dsn#"
username="#request.dbuser#" password="#request.dbpass#">
SELECT T.ticketID
FROM Tickets T
AND month(dateCreated) >= <cfqueryparam cfsqltype="CF_SQL_INTEGER"
value="#DatePart("m", f_date)#">
AND year(dateCreated) >= <cfqueryparam cfsqltype="CF_SQL_INTEGER"
value="#DatePart("yyyy", f_date)#">
ORDER BY T.ticketID
</cfquery>
but how can I compare the Day? I'm looking for something that will work on
MySQL as well as MSSQL. Any ideas?
Cedric
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
