Re: Query of Session?

2008-09-30 Thread Ian Skinner
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

RE: Query of Session?

2008-09-30 Thread Rick
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

Re: Query of Session?

2008-09-30 Thread Adrian Moreno
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

RE: Query of Session?

2008-09-30 Thread Rick
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

RE: Query of Session?

2008-09-30 Thread Adrian Lynch
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

Query of Session?

2008-09-30 Thread Rick
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 ~~~