Thanks, everyone, for the feedback.
I *finally* got this stupid (that's the headache talking)
query working. Seems like working with comparing dates
in queries has always been a chore. Mostly because I do it
rarely.
And, everyone was right, I did have MySQL working on the
part that CF should have been processing.
I did mention in an earlier post that it was MySQL 5.
Anyway, here's what finally worked:
select totalNew
from 04a_dailyNumberNewHMLSProperties
where day(date_add(dateOfTotal, interval -1 day)) =
#dateFormat(dateAdd('d', -1, now()), 'd')#
Now I can rest in peace. (or pieces if my headache
does finally split my head)
Have a good evening everyone!
Rick
-----Original Message-----
From: Bryan Stevenson [mailto:br...@electricedgesystems.com]
Sent: Friday, November 05, 2010 4:50 PM
To: cf-talk
Subject: RE: I think I'm just making this way too hard...
Apologies Rick....I now see that dateOfTotal is the new column name.
You have it backwards....you are using the DB function (date_add()) on
now() and should be using dateAdd() (CF function)....likewise...where
you are using dateAdd() you should be using date_add().
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: br...@electricedgesystems.com
web: www.electricedgesystems.com
Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments.
Please consider the environment before printing this e-mail
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:338872
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
