Then you just found the answer almost all of us would have given - GetRows()
GetRows is great in that you can close your connection and still have the data exactly as you received it. I highly recommend AGAINST session variables though. What is it that's going in this SESSION variable and how often will it be called? Will everyone have this variable set? Is it different for each user? If possible, make it an application variable. If not, keep looking for something other than SESSION because it's not the greatest answer to your problem. Chris Tifer ----- Original Message ----- From: "Aidan Whitehall" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Monday, September 30, 2002 9:42 AM Subject: RE: Converting recordset to an array... [solved, I think] Just found a page that has a really good explanation of the Recordset to Array part of the q. http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=161 I guess the rest is pretty straightforward. -- Aidan Whitehall <[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
