plus 1 ;-) DB functions for DB columns...CF functions for values!
On Fri, 2010-11-05 at 12:25 -0700, Ian Skinner wrote: > On 11/5/2010 12:14 PM, Rick Faircloth wrote: > > What am I doing wrong? (Besides mostly likely making this > > waaaaay harder than it should be... just fog on the brain today) > > > > Rick > > > > I suspect that "datatime" is a column name in your database scheme. IF > so that would mean you are trying to use a ColdFusion function to parse > the value of a database column in the record set from a sql query inside > the <cfquery...> block used to send the SQL statement to the database to > ask for a recrord set. > > Or, maybe, more simply -- you have put the cart before the horse. > > You need to be using a database function around the database column, > which for date functions varies from DBMS to DBMS. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338864 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm