Hi all
Long time ColdFusion user, new to ASP. Like it a lot but am hitting a
few stumbling blocks. I want to execute a query and then store the
results in a session variable. I was looking to do something like this:
Dim Query, etc
Execute Query
Dim Array(Query.Recordset)(3)
Loop Query
Array(TotalRows + 1)(1) = FirstField
Array(TotalRows)(2) = SecondField
Array(TotalRows)(3) = ThirdField
End loop
Session("MyName") = Array
Couple of Qs...
1) Is this the best way of storing three fields from a recordset as an
array in memory?
2) What's the syntax for getting the total number of records in a
recordset? I've been reading that using RecordCount returns -1 in some
circumstances, but can't find the syntax to just output the record count
to the screen.
Thanks
--
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 PROTECTED]
