Yup, that's certainly a disadvantage, but here's the rules I follow for
it:
1. I don't use CACHEDWITHIN or CACHEDAFTER on a query that relies on
any input the ever came from a user. Use it for SELECT abbreviation
FROM states, but not SELECT fullname FROM states WHERE fullname =
'#form.fullname#'.
2. If I need to cache something that contains anything that was, at one
time, user input, I'll use variable based cashing instead, by caching
the query into a persistent scope. <cfquery
name="session.qStateFullName" datasource="#dsn#">SELECT fullname FROM
states WHERE fullname = '#form.fullname#'</cfquery>
-Joe
-----Original Message-----
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 16, 2004 8:27 AM
To: CF-Talk
Subject: RE: SQL query style (WAS: SQL search query)
I agree in theory, but you can't use it with cached queries.
>
> You should ALWAYS use CFQUERYPARM on EVERY query, no matter
what
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]