Why are you talking about application variables? Are you suggesting a
struct of different keywords?
Since the queries will be different for each user (using different
keywords), and the refinement/paging would be per user, the session
scope would make sense, right? No need for caching through cfquery
(which prohibits cfqueryparam, which is a no-no for me, and would
require a unique name for each session or the query would be the same
for all users)
--
Hugo Ahlenius
-------------------------------------------------------------
Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
Project Officer Phone: +46 8 230460
UNEP GRID-Arendal Fax: +46 8 230441
Stockholm Office Mobile: +46 733 467111
WWW: http://www.grida.no
-------------------------------------------------------------
| -----Original Message-----
| From: Micha Schopman [mailto:[EMAIL PROTECTED]
| Sent: Thursday, July 29, 2004 16:09
| To: CF-Talk
| Subject: RE: The search is killing the server. Please help!
|
| You have 2 options,
|
| Use cfquery to execute the stored procedure (I prefer this
| method, much better readable instead of that ugly
| cfstoredproc tags) and then cache it. Or define a sql code
| based variablename based on the parameters in the sql to
| store the data into an application variable.
| Micha Schopman
| Software Engineer
| Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel
| 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo
| 39.48.05.380
|
|
|
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
