Re: query database new (date related) records?

[Jochem van Dieten]

<cfset twodaysago = DateAdd("d", -2, Now())>

<CFQUERY NAME="newphotos" >
SELECT *
FROM   mytable
WHERE  date_added > <cfqueryparam cfsqltype="cf_sql_date"
value="#twodaysago#">
</CFQUERY>

Jochem

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---