<cfquery name="report" datasource="wweb_status_internal">
<!--- Select top 1 * lists first record--->
Select *
>From maintenance_report
Where id = id and "#left(maint_report_date,2)#" = "#dateFormat(Now(), "MM")#"
Order by id desc
</cfquery>
I'm isolating the first two chars of the date (i.e. 04/05/2004) lets say "04" and comparing to the month value in the where statement.
I'm getting an: "Cannot use empty object or column names. Use a single space if necessary" error.
I know my Where comparison on the date is wrong. Any ideas please?
Thanx...as always...especially today.
Robert HWW
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
