CFML::Simple Query for date functions need help plz

[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?

[Boogle]

You need a variable which is tapped into the System.DateTime.Now() and then you would use this variable in your query:

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

HTH's

Boog's