I tend to use the CachedWithin option in the CFquery and set it to the same
time as the length of the session.... If I want to re-search etc then I set
the cachetime on the initial search to 0.


from there I can then use cfoutput with the startrow and maxrows attributes
to pull out only 10, 20, whatever columns at a time on lots of pages and I
only hit the database when I need to. Works a treat.


Paul
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to