Webmaster Forum - View Single Post - CFML::Simple Query for date functions need help plz

Boogle · 12-15-2007, 09:38 AM

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

Code:

<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

12-15-2007, 09:38 AM	#2 (permalink)
Boogle Contributing Member Join Date: 09-03-07 Location: England Posts: 391 iTrader: 0 / 0% Latest Blog: None	You need a variable which is tapped into the System.DateTime.Now() and then you would use this variable in your query: Code: <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 __________________ Price is what you pay... Value is what you get.