Ahh, I see what you're saying now. If you're just passing "Now()" through to
the DB rather than having CF evaluating it, you'd definitely want to avoid
caching it.
Ken
> It's just that I thought CF never actually *reads* the SQL, just passes it
> along.... hmm?
>
> To clarify what I was asking, in a query like this:
>
> <cfquery...>
> SELECT EventID FROM Event WHERE EventDate > Now()
> </cfquery>
>
> the SQL code *doesn't* change as Now() is handled by the db engine, not by
> CF. CF doesn't know the names of all functions in all databases,
> so I assume
> that where we write a query that is dynamic in this way, we must make sure
> it doesn't get cached manually.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
