[thelist] CF date comparison problem

[jeff]

<ol>,

:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: Oliver Lineham
:
: > how exactly do you propose to use the
: > datecompare() function in a query?
:
: i had assumed he wanted to check a date within
: a page - after it had been pulled from the database
: - because he didn't write show.showdate >= #now()#
:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

if that had been the case it would have been

show.showdate GTE Now()

cf doesn't use the usual comparison operators that most languages use.

there's also the possibility that he was trying to use the internal, access
specific, now() function of the database to retrieve the date as opposed to
the cf function now() to retrieve the date.

thanks,

.jeff

name://jeff.howden
game://web.development
http://www.evolt.org/
mailto:jeff at members.evolt.org