[thelist] CF date comparison problem
jeff
jeff at members.evolt.org
Fri Jan 12 21:01:31 CST 2001
<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
More information about the thelist
mailing list