[Foxtrck]

Hi,

What I am trying to achieve is a query that will list dates for football games for a specific team, I want the query to auto update itself if all the dates are in the DB. Basically if the date on the fixture has already been it shouldn't show, there should only be future dates. I've used:

<CFQUERY NAME="SHOWTEAMFIXTURES" DATASOURCE="x">
	SELECT * FROM ontheball_fixtures WHERE HometeamID =#ID# OR AwayteamID=#ID#
	ORDER BY Date DESC
</cfquery>

I tried adding

AND Date > now()

as It seemed pretty logical but it deosn't like this. Anyone give me any pointers?