This worked with MS Access, but I'm getting an error with this now... <CFQUERY Name="GetClients" Datasource="#DSN#">
Select ClientID from clients C where Day(AccountCreationDate) = #Form.Day# and Month(AccountCreationDate) = #Form.Month# and Year(AccountCreationDate) = #Form.Year# </CFQUERY> Here's the error: [TCX][MyODBC]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(AccountCreationDate) = 18 and Month(AccountCreationDa The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (34:218) to (34:263). Thanks! Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
