cfif not working

what is the exact value of your #date# variable? is it a date object or
a date as text string?

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

OK. Sorry about that. It isn't throwing any errors. It just isn't updating like it should. Here is the example: http://tinyurl.com/dedtwv

There are #all.RecordCount# tips in total! This is tip #AllDayRandom#... The current time is #now()# The stored date is #date# <br>
The date difference is #Abs(DateDiff("d", "#date#", "#now()#"))#
This is just tracking so I can see what is going on.

What is supposed to happen is this. The application has 2 tables. 1 of the tables is a single row with 2 columns. date and random_number. It's set up so there is no primary key because basically I'm using it as a variable that gets overwritten. Now what happens is when you visit the page, it is supposed to do a check against the current date and the date stored in the table. If the difference is 1 or more, i.e. it's not today, the query updates the table with the current date and sets a new random number. Then runs the query and displays the new tip of the day based on that new random number. Otherwise it runs through the else block. i.e. it is the same day.

Now, if I remove the if block, it works fine. However, inside of the if block it doesn't work, it just goes right to the cfelse part.

Hope that's clear...

now() returns the current date and time down to less than a second. Depending on what your date variable is, it will either never be the same as now(), or will only do so very briefly.

it is usually just excessive - adds unnecessary processing.
it can be plain bad sometimes, too.
in this case, i'd say it depends on what the value of #date# is - a date
object or a text string...


Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

Since you mention it Azadi, is

DateDiff("d", "#date#", "#now()#")

bad or just excessive compared to

DateDiff("d", date, now())

1) define "not working", please. post any errors thrown by cf.
2) what is the value of #date# variable and where is it coming from?
3) easy on the " and # - you have way more of both of them than needed!

that's for starters...

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/