> > Anybody know what CF does with queries where the dynamic behaviour is
> > handled by the database (i.e. the SQL query doesn't change but
> the results
> > do), e.g.
> > ... WHERE TheDate > Now()
> In the example given above, the SQL query changes as every second ticks by
> so it'll never be cached.
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.
