Hi,
I'm trying to query my DB to match records against the current month. I
need to use the #month# syntax against one of the tables in my DB but it's
producing a load of errors:
<cfset today = #createODBCDate(Now())#>
<cfquery name="ad_number" datasource="localads">
SELECT * from advert_details WHERE #month(start_date)# = #month(today)#
</cfquery>
Can anyone point out where I'm going wrong..?
Thanks
Will
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
