I just want to run a query that compares a column value from today
to the column value of yesterday on a MySQL 5 database table.
I run:
select totalNew
from 04a_dailyNumberNewHMLSProperties
where '#dateFormat(datetime, 'mmm d, yyyy')#' =
'#dateFormat(createODBCDateTime(dateDiff('d', '-1', now())), 'mmm d,
yyyy')#'
and I get this error:
"Variable DATETIME is undefined."
The table "04a_dailyNumberNewHMLSProperties" has
the following columns:
countID (integer, auto-increment)
totalNew (integer)
datetime (timestamp, default "CURRENT_TIMESTAMP", e.g. 2010-11-05 15:04:20)
What am I doing wrong? (Besides mostly likely making this
waaaaay harder than it should be... just fog on the brain today)
Rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:338860
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
