Now() is for CF
GetDate() is for SQL
Nat Papovich
ICQ 32676414
"Whatever you do may seem insignificant,
but it is most important that you do it." -M. Gandhi
-----Original Message-----
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 28, 2000 8:15 PM
To: [EMAIL PROTECTED]
Subject: RE: CF Caching (was New Job..)
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.
------------------------------------------------------------------------------
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.
