Rick you aren't even referencing a DB column anymore???
where date_add(now(), -1 days) = '#dateAdd('d', -1, dateOfTotal)#'
You are comparing the current date -1 day (date_add(now(), -1 days)) to
some date you have -1 day ('#dateAdd('d', -1, dateOfTotal)#')
There is no point to using date_add() as you are not performing that
function against a column in the DB (like your original issue stated).
As far as dateOfTotal not being defined.....would have to see the code
where you set it to know why it's not being seen as defined.
Perhaps sticking with your original query and using the date_add()
function for the column.
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: [email protected]
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:338869
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
