Hi All,
i am having a heap of trouble with my SQL statement in CF. The code is as shown ...
<cfquery name="GetArchives" datasource="DSN">
SELECT *
FROM Newsletter
WHERE NewsDate > '31/12/99'
AND Status='Archive'
AND Publish='Publish'
ORDER BY NewsDate;
</cfquery>
Show : #DateFormat(NewsDate, "dd/mm/yyyy"
#
I am using MS Access as the db (not my choice, its the clients!). The problem is that I can't get past my sql query, heaps of trouble. Any ideas??
The main aim to to produce a list of results inbetween the dates 1/1/99 and 31/12/99. Thanks for your sugestions.
Matt
i am having a heap of trouble with my SQL statement in CF. The code is as shown ...
<cfquery name="GetArchives" datasource="DSN">
SELECT *
FROM Newsletter
WHERE NewsDate > '31/12/99'
AND Status='Archive'
AND Publish='Publish'
ORDER BY NewsDate;
</cfquery>
Show : #DateFormat(NewsDate, "dd/mm/yyyy"
#I am using MS Access as the db (not my choice, its the clients!). The problem is that I can't get past my sql query, heaps of trouble. Any ideas??
The main aim to to produce a list of results inbetween the dates 1/1/99 and 31/12/99. Thanks for your sugestions.
Matt