Rick wrote:
> Now I want to query that session results much the
> same way as you would do a query of Query.
Then why not use the query of query? Having the result set in a session
variable does not matter. The query of a query needs a variable with a
result set in it. Provide it the session
September 30, 2008 2:10 PM
To: cf-talk
Subject: Query of Session?
I have a large amount of data returned from a database using a query and I
write it to a session. Now I want to query that session results much the
same way as you would do a query of Query.
Isn't this possible?
I w
It's possible and it's also a good way to kill your server.
Think of how much memory it would take to store a single record set in session.
Now think of how many sessions you have on average. Finally, picture how much
memory it would take for 10% of those sessions to store large amounts of data
Aditional info:
When I write the session I do this:
-Original Message-
From: Rick [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2008 2:10 PM
To: cf-talk
Subject: Query of Session?
I have a large amount of data returned from a database using a query and I
write it to a session
Yup:
SELECT *
FROM SESSION.yourQueryData
Adrian
-Original Message-
From: Rick [mailto:[EMAIL PROTECTED]
Sent: 30 September 2008 20:10
To: cf-talk
Subject: Query of Session?
I have a large amount of data returned from a database using a query and I
write it to a
I have a large amount of data returned from a database using a query and I
write it to a session. Now I want to query that session results much the
same way as you would do a query of Query.
Isn't this possible?
I want to build a "Search within these Results".
Thanks.
Rick
~~~
6 matches
Mail list logo