Cedric Villat wrote:
>
> <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>
<cfquery name="getTicketCount" datasource="#request.dsn#"
username="#request.dbuser#" password="#request.dbpass#">
SELECT T.ticketID
FROM Tickets T
WHERE dateCreated >= <cfqueryparam cfsqltype="CF_SQL_DATE"
value="#f_date#">
ORDER BY T.ticketID
</cfquery>
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Get the mailserver that powers this list at http://www.coolfusion.com
