Hello All, This might be a stupid question, but I can not figure it out.
The following code <CFSET Time_Start = #Now()#> <CFQUERY Name="UserNum" Datasource="Source"> SELECT User_Name FROM TableName WHERE (#Time_Start# - User_Data) LT #Active# </CFQUERY> The problem I am getting is the point of WHERE (#Time_Start# - User_Data) LT #Active# It is telling me that User_Data (which is a column in my access DB) is not found. How would I make this work??? ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists